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

Copper Contributor

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?

Lindsay_Harris_0-1692981231441.png

Lindsay_Harris_1-1692981276412.png

 

 

1 Reply

@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.