Vlookup on mixed data types

A

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
 
D

Don Guillett

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