Match data uneven columns

  • Thread starter Thread starter Diddy
  • Start date Start date
D

Diddy

Hi,

I have values in A and I would like to compare that with a list of values in
B. All of the values in B will be in A but the values in A may not be in B.

What I would like to have happen is for the corresponding B value to line up
on the same row as the A value.

Does that make sense at all?

Thanks
Diddy
 
In helper column C:
=IF(ISNUMBER(MATCH(A2,B:B,0),A2,"")
Copy down as needed, then either hide column B, or copy, paste special -
values.
 
Back
Top