Match data uneven columns

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
 
L

Luke M

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

Diddy

Thank you Luke,

I added a bracket
=IF(ISNUMBER(MATCH(A2,B:B,0)),A2,"")

Many thanks
Diddy
 
Top