General discussion
April 5, 2005 at 03:18 AM
samtitus

Exel Formula

by samtitus . Updated 21 years, 3 months ago

This is what I would like to do: I would type an amount in col A and in col B it would automatically enter a matching amount. If a matching amount is not found it must give me an error message in col B “No match found”.
EG
Col A Col B
R28.77 R18.30
R101.22 R88.39
R57.00 R43.66
R28.87 no match found
R103.80 R89.46
R116.40 no match found

This discussion is locked

All Comments