I am struggling with this and I am sure someone could help me. I have a
spreadsheet with account number and description in two columns. This is a
master Chart of Accounts. The account numbers are 8 digits. In the same
spreadsheet, another worksheet has account number and description of the
account. The account numbers are 4 digits in this worksheet. Further the
account numbers have no relationship to the master, meaning the master
worksheet could have account 35110001 and the other worksheet will have 3429
with the same description as "Fees". Therefore my only choice is to use
either VLOOKUP or MATCH (exact) for the description in both worksheets.
However I get #NA as the result. But if I copy "Fees" from Master worksheet
and paste to the other worksheet containing the same description "Fees",
then the formula finds a match. I have 1985 rows to play with. Is there a
simple solution?
Thank you so much for your help.
Krish