lookup tables

[Guest]

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

 

[Rowan Drummond]

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

 

[Rowan Drummond]

Correction:
=VLOOKUP(A1,$B$2:$C$5,2,FALSE)

Regards
Rowan