Match data uneven columns
 

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

Match data uneven columns
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Diddy" wrote:

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

Match data uneven columns
 

Thank you Luke,

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

Many thanks
Diddy




"Luke M" wrote:

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Diddy" wrote:

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