Vlookup to Equal Zero?
 

Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you

Vlookup to Equal Zero?
 

Something like this should do

=if(countif('9-7Turnover'!$A$1:$A$32, A2) = 0, 0, VLOOKUP(A2,
'9-7Turnover'!$A$1:$F$32, 6, FALSE))
--
HTH...

Jim Thomlinson


"57Caddy" wrote:

Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you

Vlookup to Equal Zero?
 

Pre-2007

=if(isna(your vlookup formula),0,your vlookup formula)

In v2007 it's

=iferror(your vlookup,0)


"57Caddy" wrote:

Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you

Vlookup to Equal Zero?
 

Try this:

=If(ISNA(Match(A2,'9-7Turnover'!$A$1:$A$32,0)),"",VLOOKUP(A2,
'9-7Turnover'!$A$1:$F$32, 6, 0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"57Caddy" wrote in message
...
Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't
find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you

Vlookup to Equal Zero?
 

Worked perfect, thank you!

"Jim Thomlinson" wrote:

Something like this should do

=if(countif('9-7Turnover'!$A$1:$A$32, A2) = 0, 0, VLOOKUP(A2,
'9-7Turnover'!$A$1:$F$32, 6, FALSE))
--
HTH...

Jim Thomlinson


"57Caddy" wrote:

Hello,

I am doing several lookups to several sheets and have attached an example
below. How can I get it to display as zero as opposed to N/A if it can't find
the item looked up?

=VLOOKUP(A2, '9-7Turnover'!$A$1:$F$32, 6, FALSE)

Thank you