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
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
- Excel intersection of two columns - Excel Forum
- Excel compare two columns for partial matches - Guide
- VBA Compare 2 sheets and output difference to 3rd sheet - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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