Forum Discussion

Lindsay_Harris's avatar
Lindsay_Harris
Copper Contributor
Aug 25, 2023

Pull dates from one sheet that relate to an invoice number listed on both sheets

Hi.

I am trying to pull dates for invoices from one excel sheet that match with an invoice number on a different excel sheet. Both excel sheets have the invoice numbers on them, but I am needing to pull the dates related to the invoice number to the sheet that only has the invoice number on it. (Please disregard the ones in red.)

Can someone help with this?

 

 

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 25, 2023

    Lindsay_Harris 

    As variant

    =INDEX(Sheet2!$E:$E, MATCH($C2, Sheet2!$D:$D, 0) )

    or so, depend on your Excel version and exact data layout.

Resources