Forum Discussion
Lindsay_Harris
Aug 25, 2023Copper Contributor
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 ...
SergeiBaklan
Aug 25, 2023MVP
As variant
=INDEX(Sheet2!$E:$E, MATCH($C2, Sheet2!$D:$D, 0) )
or so, depend on your Excel version and exact data layout.