Thread: VLookup Query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KIWI KIWI is offline
external usenet poster
 
Posts: 10
Default VLookup Query

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