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 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 8, 2011 at 04:13 PM
use VLOOKUP
0
Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,169
Feb 8, 2011 at 04:15 PM
Alleluia! Praise the Lord! Rizvisa1 is back!
0