Check other page for data and insert

[ExtremeNewb]

Hello, I have been struggling with this for quite some time now. Basically am trying to have it do is check the other sheet and match the name with what is in column F and A of both sheets then put the price in column C (From E of the other sheet). How would I do this?

 

[Andrew Poulsom]

Welcome to MrExcel.

Here's an example:

=INDEX(Sheet2!C:C,MATCH(1,INDEX((Sheet2!A:A=A1)*(Sheet2!F:F=F1),),FALSE))

Adjust the range and worksheet references to suit. Also try to avoid using entire columns.

 

[ExtremeNewb]

Andrew, Thank you for responding! The data I need to match is in Column F (sheet is named PRICE-Master.xlsx) and i need to match it with column A of the second sheet (named backup1-edited1.csv) And I need it to insert the information from Column D of Price-master into column C of backup1-edited.csv if the data in Column F and A match. What would I put? Sorry I am so dense.

 

[Andrew Poulsom]

I need the worksheet names as well as the file names.

 

[ExtremeNewb]

Andrew thank you so much for replying. I have been sitting here refreshing for the past few hours hoping someone would respond! The file name is Backup2-Edited.csv and PRICE-Master.xlsx. Once again thank you!

 

[Andrew Poulsom]

What are the names of the worksheets in those two workbooks?

 

[ExtremeNewb]

Sorry. In PRICE-Master.xlsx the worksheet is named sheet1 and in Backup2-edited.csv its Backup2-edited.csv

 

[Andrew Poulsom]

In C1 on sheet Backup2-edited:

=INDEX('[PRICE-Master.xlsx]Sheet1'!D:D,MATCH(A1,'[PRICE-Master.xlsx]Sheet1'!F:F,FALSE))

 

[ExtremeNewb]

You are my hero. Thank you so much.