Hi,
please see attached
look up formula is returning the wrong text from my look up table.
eg store name in column A, state in column B
cell A2 returing WA instead of SYD.
Formula that i am using is:
=LOOKUP(A1,lookup_table!$B$1:$B$38,lookup_table!$C$1:$C$38)
Many Thanks
Natalie