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

Report
Posts
1
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 28, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
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

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi JD,

The VLOOKUP formula will do the job for you.

Try it and let us know if you get stuck.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!