Vlookup and matching help

[joshrussin]

From here down is what I am trying to get from the excel sheet.

I am trying to upload the raw file here and get the results that I need

PO Product Batch, needs to be created in both sheets (eWM and ECC)

The result is a column that shows the lead time

(eWM)   "PO Product Batch" = "Purchase Order" & ' ' & Product & ' ' & Batch

(ECC)   "PO Product Batch" = "Purchase Order" & ' ' & Material & ' ' & Batch

(ECC)   In excel, define name for "PO Product Batch" and "Posting Date", call it ECCPO

(eWM)   Create a new column called "ECC Posting"

(eWM)   VLOOKUP in this column (=vlookup("PO Item Batch column", ECCPO, 2, false)

     this pulls in ECC posting date for each PO Item Batch combo

Format to date field

(eWM)   Add "Lead Time" column = sum(networkdays("Putaway Date (Act.)"- "ECC Posting"

Attached is a raw file within the app and the excel with the correct data

Can anyone please help me with this?