Finding a match and pasting next to it

D

Donna S

I have a list in column A and a list in column G. I want start at the top of
column G and find the each cells match in column A and past the info in the
cells from columns G - H in the cell B & C of the matched cells. So basically
I'm lining up info based on two matched columns. Please help.
 
B

Bernard Liengme

Assuming list start in A2 and G2 and go to row 101
in B2 use =VLOOKUP(A2,$G$2:$H$5,1,FALSE) (of course, the result will equal
A2)
in C2 use =VLOOKUP(A2,$G$2:$H$5,2,FALSE)
best wishes
 
D

Donna S

Thanks but that's not quite what I'm looking for.

My lists are not same and are not in order

If I start with cell G2 I need to find the matching value of the cell in
column A. Once it is identified (say I find it in A13) I need to cut and past
cells g2 - I2 into corresponding cells b13 - d13.
 
Top