Find and compare calues in two columns

mswonderer Posts 1 Registration date Wednesday July 31, 2013 Status Member Last seen July 31, 2013 - Jul 31, 2013 at 09:05 AM
 mswonderer - Aug 2, 2013 at 07:08 AM

i need to look for values (strings) in column A and see if exist in column B. if exist return the line number.

(tried vlookup but i get only the answer if exist or not but not the specific place.)


1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 2, 2013 at 05:17 AM
suppose data is like this in A and B

1 v
2 v
3 2
4 x
5 x

in c1 type this formula
copy this formula down.

i did something else eventually: vlookup(e:e,$a$2:$c:$200:3:0) and drag it down .

e is the column with the list of strings
a-c is the array while in a i have the lokked for column and in c i have the line numbers)

as a result i receive the line number if a match found, and n/a if no match.

thanks for the support