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
Related:
 Find and compare calues in two columns
 Display two columns in data validation list but return only one  Guide
 Beyond compare  Download  File management
 Compare two worksheets and paste differences to another sheet  excel vba free download ✓  Excel Forum
 How to compare two Excel sheets with varying data ✓  Excel Forum
 Vba find column by name ✓  Excel Forum
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
ac 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