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
Sheet 2:
Column C invoice number
column J Actual Hours
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 |