Vlookup on mixed data types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to search mixed type (Text and numeric) data on a spread sheet
using the Vlookup function and all I get as a result is #N/A. Thank you for
any assistance.

Andy
 
try using match instead, witht the -1 option for numbers and ,0 for data
=MATCH(250,K1:K6,-1)
 
Back
Top