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
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
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
Related:
- Find and compare calues in two columns
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
- How to delete rows and columns in word - Guide
- Excel compare two sheets - Guide
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
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.
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.
Aug 2, 2013 at 07:08 AM
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