VLOOKUP & #N/A

[Phil T]

Can you use VLOOKUP or another function to return a zero
value rather than #N/A if false

 

[Frank Kabel]

Hi Phil
try
=IF(ISNA(VLOOKUP(.....),0,VLOOKUP(....))

HTH
Frank

 

[Bob Phillips]

Hi Phil,

Use

=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

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

 

[Guest]

Thanks for prompt answer - can you guide me in!

example: DATA TABLE
A B
1 GOODS VALUE
2 item 1 10
3 item 2 20
4 item 3 30
5
6 item 1 =vlookup(a6,a1:b4,2,false) - gives me 10
7 item 4 =vlookup(a7,a1:b4,2,false) - gives me #N/A

what should the ISNA formula be to get B7 to show zero?

thanks again

 

[Frank Kabel]

Hi
try the following
=IF(ISNA(vlookup(a7,a1:b4,2,false)),0,vlookup(a7,a1:b4,2,false))

HTH
Frank