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

Something went wrong.
Something went wrong.
Something went wrong.
dbr2598: 0

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step -1 - =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),"")