Need a Macro to Compare a cell in one sheet to a range in another and copy a specified cel

[jlshipley]

I need some help if anyone would be able to provide it - I have tried multiple things and nothing works like I need it to.

I have a sheet named "test" on the sheet named "test" I have a row beginning in Column "D2" ending in "D23" - I need to compare the cell in "D2" to a range in sheet "test2" the range is "A2:A100" - if a match to cell "D2" in sheet "test" matches any cell on sheet "test2" range "A2:A100" I need to copy the corresponding cells in sheet "test2". For example is cell "A8" in "test2" matches cell "D2" in sheet "test" I need to copy cells "B8"&"C8" from sheet "test2" and copy them and past to sheet "test" cells "G2"&"H2".......I need this to repeat for all cells in row "D2:D23" in sheet "test"


I hope that makes sense - if anyone can help I would greatly appreaciate it.


Thanks to all of you in advance,

[alansidman]

The vlookup function if placed in cells in columns G and H will accomplish this for you.

Starting with G2: =vlookup(A2, 'test2'!$A$2:$C$100,2,False)
In H2: =vlookup(A2,'test'!$A$2:$C$100,3,False)

and then copy them down.

Look at this link for further understanding. http://www.techonthenet.com/excel/formulas/vlookup.php

[jlshipley]

alansidman


Thnak you very much!!! I had given up on the Vlookup because I was appearently doing something wrong! Thank you sooo much what you said worked perfectly!!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the feedback and Rep