Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match or VLOOKUP
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup worksheet match in macro | Excel Worksheet Functions | |||
Partial String Match Using VLOOKUP | Excel Worksheet Functions | |||
Tricky ... Pullout related rows that match a single word using Vlookup | Excel Discussion (Misc queries) | |||
is there a way to search with vlookup to match more than 1 column | Excel Discussion (Misc queries) | |||
Vlookup, Index & Match | Excel Worksheet Functions |