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

Copper Contributor


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?





1 Reply


As variant

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

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