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

VLookup Query
 

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

VLookup Query
 

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)

--
Biff
Microsoft Excel MVP


"Kiwi" wrote in message
...
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

VLookup Query
 

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


"eksh" wrote:

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

VLookup Query
 

Thank you both this is great.
--
Thanks as always

Kiwi


"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Kiwi" wrote in message
...
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


.

VLookup Query
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Kiwi" wrote in message
...
Thank you both this is great.
--
Thanks as always

Kiwi


"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Kiwi" wrote in message
...
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


.