VLOOKUP Function

Puntarenas · Apr 28th, 2002, 08:12 PM

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 · Apr 28th, 2002, 08:19 PM

Try this thread:

http://www.mrexcel.com/board/viewtop...c=6252&forum=2

Yogi Anand · Apr 28th, 2002, 08:22 PM

Quote:

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 · Apr 28th, 2002, 08:53 PM

Yogi,
Thanks...it worked.
JAC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 28th, 2002, 08:12 PM	#1
Puntarenas New Member Join Date: Apr 2002 Posts: 6	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)

Apr 28th, 2002, 08:19 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try this thread: http://www.mrexcel.com/board/viewtop...c=6252&forum=2

Apr 28th, 2002, 08:53 PM	#4
Puntarenas New Member Join Date: Apr 2002 Posts: 6	Yogi, Thanks...it worked. JAC