if one set is in a1:a500, and the other set is in b1:b500, just put
=match(b1,$a$1:$a$500,0) in c1 and copy down to c5000.
You will get a N/A for a numbers in column b not found in column a
if one set is in a1:a500, and the other set is in b1:b500, just put
=match(b1,$a$1:$a$500,0) in c1 and copy down to c5000.
You will get a N/A for a numbers in column b not found in column a
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks