S
Seanie
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?
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?