Why troubling yourself in typing all these manually.
Formulas can do that for you.
Main formula cell--H3
Each time you want to input labour rate, just copy the main formula cell and paste in the desired range.
![]()
=INDEX(INDIRECT("Sheet2!C"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":C10000"),MATCH(RIGHT($C3,LEN($C3)-FIND("/",$C3)),INDIRECT("Sheet2!B"&MATCH(LEFT($B3,FIND("/",$B3)-1),Sheet2!$A:$A,0)&":B10000"),0))
Bookmarks