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

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

<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>
</tbody>

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