I need a help,, how to do the following

Occasional Visitor

i have excel file (A) with PO numbers and approval date , and another excel (B) with PO numbers only without approval date, i want to match the two PO columns in the two excel files (A and B) and wherever there is a match (same PO number) i want to take the approval date from excel file (A) and place it in excel file (B) next to PO number

1 Reply

@lawatifhmy 

Let's say the PO numbers are in column A on both sheets, and the approval dates in column B, starting in row 2.

 

Open both workbooks.

Activate workbook B.

Select cell B2 (currently empty).

Enter the following formula:

=IFERROR(VLOOKUP(A2, '[Workbook A.xlsx]Sheet1'!$A$2:$B$100, 2, FALSE), "")

where Workbook A.xlsx is the name of the workbook that already has the approval dates, and Sheet1 is the name of the sheet with those data. If necessary, expand the lookup range.

Format B2 as a date.

Fill down to the last row with a PO number.

You should now see the dates for the matching PO numbers.

Close workbook A. Excel will automatically add the path of this workbook to the formulas in workbook B.

Save workbook B.