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