#NA

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Involved VLookup Function 6
Vlookup with Pivot Table 1
removing #na from a sheet 7
replacing a #na 2
problem with Vlookup in macro 2
Deleting #NA in a Spreadsheet 5
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP 12
Lookup value in table without returning #N/A 3

Top