VLOOKUP Function

[Puntarenas]

When I use the VLOOKUP function and I use (Ex. =vlookup(A2,'Filename',A1:A20,2,false), when 'false' applies, it gives the result of "#N/A", I want to place a numeric value (such as zero)

 

[Brian from Maui]

Try this thread:

http://www.mrexcel.com/board/viewtopic.php?topic=6252&forum=2

 

[Yogi Anand]

On 2002-04-28 19:12, Puntarenas wrote:
When I use the VLOOKUP function and I use (Ex. =vlookup(A2,'Filename',A1:A20,2,false), when 'false' applies, it gives the result of "#N/A", I want to place a numeric value (such as zero)

Welcome to the board. Use the following formula:

=if(isna(your_vlookup_function),0,your_vlookup_function)

Hope This Helps!

 

[Puntarenas]

Yogi,
Thanks...it worked.
JAC