vlookup result
 

In a VLOOKUP function when the range lookup is set to false, is it possible
to have excel return a "0" versus a N/A Value?

Thanks in advance for your assistance!
--
icebreaker914

vlookup result
 

One way:

=if(iserror(yourvlookupformula),0,yourvlookupformu la)



icebreaker914 wrote:

In a VLOOKUP function when the range lookup is set to false, is it possible
to have excel return a "0" versus a N/A Value?

Thanks in advance for your assistance!
--
icebreaker914

--

Dave Peterson

vlookup result
 

One way:

=IF(ISNA(MATCH(A1,J:J,FALSE)),0,VLOOKUP(A1,J:K,2,F ALSE))

In article ,
"icebreaker914" wrote:

In a VLOOKUP function when the range lookup is set to false, is it possible
to have excel return a "0" versus a N/A Value?

Thanks in advance for your assistance!

vlookup result
 

Thanks Dave, it works great!
--
icebreaker914


"Dave Peterson" wrote:

One way:

=if(iserror(yourvlookupformula),0,yourvlookupformu la)



icebreaker914 wrote:

In a VLOOKUP function when the range lookup is set to false, is it possible
to have excel return a "0" versus a N/A Value?

Thanks in advance for your assistance!
--
icebreaker914

--

Dave Peterson