Match values from two different columns on two sheets (same workbook) and give result from a 3rd col

Occasional Visitor

Hi, 

Will try to do this request in bullet point: 

  • Workbook will be adding a sheet each day with similar data
  • Need to match certain data from previous day to current day
  • Data will be taken off and added day to day; therefore rows will not be same (VLOOKUP - couldn't work).
  • Columns are not side by side - multiple columns in worksheet. (example shows side by side) - Result column is about 8 columns over from the columns I need to match. 

Can't figure out how to add attachment - here are the two worksheets. 

 

Sheet One

Customer requisitionSales orderSerial Number
1024-123912S000001410F0000237993
B32254S000000012F039248709834
R000000493S000002507F0000237993
R000000493S000002522F0000238801
R000000498S000002525F0000457326
R000000498S000002530F0000458802

 

Sheet Two

Customer requisitionSales orderSerial Number
B32254S000000012 
1024-123912S000001410 
R000000493S000002507 
R000000498S000002525 

 

Hope this helps.  Thank you. 

1 Reply

@Heather2050 

=INDEX($F$3:$F$8,MATCH(1,(A12=$D$3:$D$8)*(E12=$A$3:$A$8),0))

Maybe with INDEX and MATCH. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

index and match.JPG