Return more than one match function

bass23

New member
Joined
Apr 30, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2013
Hi everyone,

I`m struggling to return the actual hours associated with the invoice number in sheet 2 to sheet 1. I tried using a match function however it only returns the first instance it finds, whereas I want it to return the actual hours for everytime invoice number(sheet1) = invoice number (sheet 2).

Sheet 1:
column B: invoice number Column J: Actual hours
9100382701
9100382701
9100382701
9100413126
9100413126
9100413126
9100413126
9100413150
9100413150
9100413150
9100413150
9100418761
9100418761
9100418761
9100418933
9100418933
9100418933
9100429220
9100429220
9100429220
9100429551
9100429551
9100440291
9100440291
9100440291

Sheet 2:

Column C invoice number
9100382701
9100413126
9100413150
9100418761
9100418933
9100429220
9100429551
9100440291
9100442972
9100459374
9100491332
9100502882
9100512590
9100512621
9100536032

column J Actual Hours
1378
1928
1928
1953
1953
2160
2170
2359
2430
2654
3272
3509
3588
3560
3963
 

Attachments

  • Matchfunction.xlsx
    9.6 KB · Views: 10
Enter the formula below on Row 2 of Sheet1 in whichever column you want the Actual Hours to appear, and copy down to row 26:
=INDEX(sheet2!$J$2:$J$16, MATCH(B2,sheet2!$C$2:$C$16,0))
 
Back
Top