Find and compare calues in two columns

Solved/Closed
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
Hi

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.)

thanks

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
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
=IF(ISERROR(MATCH(A1,$B$1:$B$6,0)),"",MATCH(A1,$B$1:$B$6,0))
copy this formula down.
0
thanks!

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
0