#NA

  • Thread starter Thread starter Carlo
  • Start date Start date
C

Carlo

Hi
Is there a way to check that if a vlookup command returns a NA then it
puts in a 0 not a NA?

I have a list where I run vlookups but if the reference does not exist
in the lookup table it returns a NA. I realise that I can run a ISNA
and check but I was hoping to have something similar to
=if(=vlookup(lookup,table,column,false)=NA,0,=vlookup(......))

Thanks
Carlob1
 
=IF(ISNA(vlookup(lookup,table,column,false)),0,vlookup(lookup,table,column,f
alse))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top