Pulling Data From Another Workbook

[rnathanwilson]

Hello all, Sorry if this question has been asked before but, I have searched all over the internet for help.

I have a Supplier Report Card which contains the following columns
DATE RECEIVED, PO, EXPECTED DATE, and SCORE

I manually (copy and paste) enter DATE RECEIVED and PO and hoping to find a solution that once the PO has been entered Excel will scan another workbook, match the PO, then retrieve the EXPECTED DATE for that PO and bring that data back to the report card. Is this even possible?

Another issue I might run into is: if the other workbook does not have the PO entered I would just like EXPECTED DATE to be blank.

So far I have tried Pivot Tables, Consolidate Workbooks, and many other options.

Is there a simple solution to this? Any help would be greatly appreciated, Thanks!

 

[Ams_A]

You can use VLOOKUP to get that Expected Date from the other workbook and add IFERROR to get a blank cell in case the PO value is not found in the other sheet.

 

[Fazza]

Welcome

The inbuilt functionality for this is a parameterised external data query. Suggest you google for examples.

An Excel 2003 example, http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/

HTH