Match Excel Data and return associated data

Closed
scotth3680
Posts
1
Registration date
Thursday February 3, 2011
Status
Member
Last seen
February 3, 2011
- Feb 3, 2011 at 10:58 PM
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
- Feb 8, 2011 at 04:15 PM
Hello,

I have an excel sheet that I am trying to match data up on. Essentially, my data looks like this:

Column A Column B Column C Column D
filename extension filename product #
image00 -001.jpg image00 3200
image00 -002.jpg image01 3201
image00 -003.jpg image02 3202
image01 -001.jpg image03 3203


What I need to do is basically match between Column A and Column C, and when a match is made, Put the data from Column D into Column E.

For example the first three rows in Column A would match on the first Row in Column C, therefore I would need the first rows of Column E to be populated with 3200, as that is the value next to the Matched data (Column C).

Can someone help me with a formula for this? Please and thank you.







1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 8, 2011 at 04:13 PM
use VLOOKUP
0
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,314
Feb 8, 2011 at 04:15 PM
Alleluia! Praise the Lord! Rizvisa1 is back!
0