Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup tables
I am building a mapping of our chart of accounts to produce financial
statements. I am using the account number as my main lookup. However, I have different branches and some of them do not have the same account numbers - so the lookup function is returning the closest value. What can I do? Thank you -- Pat |
#2
|
|||
|
|||
lookup tables
If must set the last argument of the lookup function to false to force
it to make exact matches eg =VLOOKUP(A1,$B$2:$B$5,FALSE) Hope this helps Rowan Pat wrote: I am building a mapping of our chart of accounts to produce financial statements. I am using the account number as my main lookup. However, I have different branches and some of them do not have the same account numbers - so the lookup function is returning the closest value. What can I do? Thank you |
#3
|
|||
|
|||
lookup tables
Correction:
=VLOOKUP(A1,$B$2:$C$5,2,FALSE) Regards Rowan Pat wrote: I am building a mapping of our chart of accounts to produce financial statements. I am using the account number as my main lookup. However, I have different branches and some of them do not have the same account numbers - so the lookup function is returning the closest value. What can I do? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to automatically populate cells using lookup tables | Excel Discussion (Misc queries) | |||
Lookup Tables with linked sheets | Excel Discussion (Misc queries) | |||
Lookup tables | Excel Worksheet Functions | |||
Using Multiple LOOKUP tables | Excel Discussion (Misc queries) | |||
lookup tables in cells | Excel Worksheet Functions |