V Lookup Help

[nmarshall]

Can Anybody Help Me with the Following VLookup Formula:

=IF(E8="Bank hol",VLOOKUP(D8,Sheet4!$H$1:$I$12,2,FALSE)*1.5,VLOOKUP(D8,Sheet4!$H$1:$I$12,2,FALSE))

I need To remove the Annoying #N/A When nothing is entered in some of the cells, and allow it to carry on working out.

Thanks

 

[nmarshall]

Thanks for your Help it was gREAT. I have managed to sort it. This is my new Formula:

=IF(E20="Bank hol",IFERROR(VLOOKUP(D20,Sheet4!$H$1:$I$12,2,FALSE),"0")*1.5,IFERROR(VLOOKUP(D20,Sheet4!$H$1:$I$12,2,FALSE),"0"))

Regards

Neil

 

[Sandeep Warrier]

You're welcome.

I'm glad you were able to sort out the problem.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[bharati]

=IF(ISERROR(VLOOKUP(E16,M16:N18,2,0)),"",(VLOOKUP(E16,M16:N18,2,0)))

=IF(F16="Bank Holiday",G16*1.5,"")