Matching cells

A

Arnie

not sure if this explanation is going to be very clear but here goes

in Column A (with header) i have a list of references ie MN001 to XY300 (
but not in order and some numbers are missing ie MN001 then goes to MN005) in
column F i have again MN001 to XY300 where all the intermediate numbers are
listed but not in the same order. i need to match Column A Cell A2 (MN001) to
Column F where the coresponding cell has the same data (MN001) the in column
B B2 copy the data there and paste it into Column G which has MN001 in column
F next to it.
I need to search about 500 rows.

A B F G
MN001 7 XY123
MN005 8 XY213
XY250 2 MN001 Paste Value 7 here in column G
 
N

Niek Otten

=IF(ISNA(VLOOKUP(C2,$A$2:$B$4,2,FALSE)),"",VLOOKUP(C2,$A$2:$B$4,2,FALSE))

Copy down as far as the data goes

Replace $B$4 with your last cell

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| not sure if this explanation is going to be very clear but here goes
|
| in Column A (with header) i have a list of references ie MN001 to XY300 (
| but not in order and some numbers are missing ie MN001 then goes to MN005) in
| column F i have again MN001 to XY300 where all the intermediate numbers are
| listed but not in the same order. i need to match Column A Cell A2 (MN001) to
| Column F where the coresponding cell has the same data (MN001) the in column
| B B2 copy the data there and paste it into Column G which has MN001 in column
| F next to it.
| I need to search about 500 rows.
|
| A B F G
| MN001 7 XY123
| MN005 8 XY213
| XY250 2 MN001 Paste Value 7 here in column G
 
Top