Help on Formula

[NoelD]

I have this table and it uses a lookup to work out "Report" column. However I need to expand the Vlookup to change the results to read the figures in the "Basis" column when the exceptions occur

[TABLE="width: 1832"]
<colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Branch[/TD]
[TD]Empl[/TD]
[TD] [/TD]
[TD]Name[/TD]
[TD]Type[/TD]
[TD]Work Branch[/TD]
[TD]Total[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[TD]Sun[/TD]
[TD]Report[/TD]
[TD]Basic[/TD]
[TD]T + 1/2[/TD]
[TD]Double[/TD]
[TD]Fitter Bonus[/TD]
[TD]Overtime[/TD]
[TD]Holidays[/TD]
[TD]Sick [/TD]
[TD]Training [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]0029MCD[/TD]
[TD]0029[/TD]
[TD]Daniel Mcdonnell[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8.39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.49[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7.89[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-30.61[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]0255MAR[/TD]
[TD]0255[/TD]
[TD]Konrad Marciniak[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]33.04[/TD]
[TD="align: right"]8.27[/TD]
[TD="align: right"]8.16[/TD]
[TD="align: right"]8.4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8.2[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]200.49[/TD]
[TD="align: right"]-5.96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]1122HUG[/TD]
[TD]1122[/TD]
[TD]Peter Hughes[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]42.37[/TD]
[TD="align: right"]8.85[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8.87[/TD]
[TD="align: right"]8.15[/TD]
[TD="align: right"]8.21[/TD]
[TD="align: right"]8.29[/TD]
[TD] [/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4.12[/TD]
[TD="align: right"]29.28[/TD]
[TD="align: right"]3.37[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]1131PEP[/TD]
[TD]1131[/TD]
[TD]Christopher Awa Pepito [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]114.72[/TD]
[TD="align: right"]9.33[/TD]
[TD="align: right"]8.57[/TD]
[TD="align: right"]9.15[/TD]
[TD="align: right"]8.82[/TD]
[TD="align: right"]8.63[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]105.95[/TD]
[TD="align: right"]75.72[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]1079DUG[/TD]
[TD]1079[/TD]
[TD]David Duggan[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]1181MCC[/TD]
[TD]1181[/TD]
[TD]Marcus Mc Cormack[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8.48[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]8.48[/TD]
[TD="align: right"]7.8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]



Formula behind "Report"!
=IFERROR(VLOOKUP(C3,'Payroll Summary'!A:J,10,FALSE)," ")

Employee 1181 hours to be reduced from 8.48 to 7.8

how can this be incorporated in to the lookup formula

Noel