By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

=match xl

Prerequisite

Vlookup

Match will search a range for a value and return an offset number

=Match("ABCDE",A:A,0)

Data table

Match returns xxxx

#N/A problem

=IfNA(match("ABCDE",A:A,0),"")