Vlookup doesn't work that way

Use index/match to easily return results from a col to the left or right of
the match col
In O101: =INDEX(Sheet3!A:A,MATCH(N101,Sheet3!B:B,0))

--
Max
Singapore

"Seanie" wrote in message
...
I am trying to use a DataValidation cell value to do a lookup and I
get #N/a

Cell N101 = a Data Validation list value
Lookup formula in O101 = =VLOOKUP(N101,Sheet3!A$3:C$248,1,FALSE)

Above returns #N/a, but the value I want is in Sheet3!A3 and N101 is
in Sheet3!B3

What am I doing wrong?