Vlookup on mixed data types

[Andy]

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

 

[Don Guillett]

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