Excel formula assistance needed!

Hi Willy, thanks so much for the reply!

I tried putting the formulas into the spreadsheet, but it comes up with #REF! when I click control + shift + enter. 

For total cost of sales, I edited the titles used so it looks like; 

=INDEX(ProfitLoss!$B$6:$FE$21, 21, MATCH(TEXT(Sheet1!$A2,"000"), MID(ProfitLoss!$B$6:$FE$6, 2, 3), 0))

The name of sheet 1 is actually 'ProfitLoss' and sheet 2 'Sheet1'. 

The last column is the spreadsheet is FE. 

I wasn't sure whether to change where it has '000' to the digits of the job number (eg. '570'), 

But when I did this it didn't give me the right number either. 

Any suggestions to where I've gone wrong?

Thanks!