Lookup Function Error

Re: Lookup Function Error

Quote from Natalie

that works but only for one cell when i drag the formula down it still returns the wrong text. It need one formula that will return the correct text for information that fills 65,000 rows in excel.

thanks

So you respond to the post and I tell you that you need to change the formula for the rows you have - all I gave you was the answer to the sample you posted!

Re: Lookup Function Error

Note that if you do sort the table and use that LOOKUP formula then it will return a "closest match", e.g. if A1 contained "WEST GARDENS", which doesn't exist in your lookup table, you'll get a result of "SYD". You probably don't want that so revise formula to:

=IF(LOOKUP(A1,lookup_table!$B$1:$B$38)=A1,LOOKUP(A1,lookup_table!$B$1:$C$38),"No Match")

This is a more efficient formula than using VLOOKUP on an unsorted lookup table, especially if you have 65000 rows