You will need some extra formula to build up something like this:
=IF(ISERROR(VLOOKUP(A4,'ASSESSMENT
3'!$A$4:$BP$1993,2,0)),0%,VLOOKUP(A4,'ASSESSMENT 3'!$A$4:$BP$1993,2,0))

Hope it helps
eksh

"Kiwi" wrote:

Hi everyone

Still rather new to vlookup but loving it so far! I have one question please
I have the following formula but if it the info does not fit into the
request it brings up #N/A how do I change it so that in this situation it
brings up 0% instead?

=VLOOKUP(A4,'ASSESSMENT 3'!$A$4:$BP$1993,2,0)


Thanks as always

Kiwi