Match value in 2 separate columns and return a value from a 3rd

Closed
JD_Silver Posts 1 Registration date Tuesday October 28, 2014 Status Member Last seen October 28, 2014 - Oct 28, 2014 at 05:33 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Oct 30, 2014 at 12:33 PM
Hello,

Here is my issue.

I have 2 worksheets within 1 workbook. I need to add a formula that will look at the value in sheet 1 column A and then look for a matching value in sheet 2 column A. If it finds a matching value in sheet 2 column A then it should return the value in sheet 2 column D for the row that contains the matching value.

Thank you so much for any assistance. I am really stuck on this one!!

Regards,
JD


1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Oct 30, 2014 at 12:33 PM
Hi JD,

The VLOOKUP formula will do the job for you.

Try it and let us know if you get stuck.

Best regards,
Trowa
0