VLookup Query

  • Thread starter Thread starter Kiwi
  • Start date Start date
K

Kiwi

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
 
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
 
If you're using Excel 2007:

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

This will work in any version:

=IF(COUNTIF('ASSESSMENT 3'!$A$4:$A$1993,A4),VLOOKUP(A4,'ASSESSMENT
3'!$A$4:$BP$1993,2,0),0)
 
Thanks Eksh but I must still be doing something wrong - this does work for
that cell however if I drag the formula down it brings me back with 0% for
everything which is not correct - am I missing a step??

Thanks for your patience

Kiwi
 
Back
Top