ExcelBanter - VLOOKUP FUNCTION AND NA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP FUNCTION AND NA (https://www.excelbanter.com/excel-discussion-misc-queries/134096-vlookup-function-na.html)

NA and VLOOKUP

VLOOKUP FUNCTION AND NA

I am trying to use the VLOOKUP function to display the value of zero if it
does not find a reference lookup. Currently if no reference is found it
display #n/a.

bpeltzer

VLOOKUP FUNCTION AND NA

=if(isna(your_lookup_function),0,your_lookup_funct ion)

"NA and VLOOKUP" wrote:

I am trying to use the VLOOKUP function to display the value of zero if it
does not find a reference lookup. Currently if no reference is found it
display #n/a.

Dave Peterson

VLOOKUP FUNCTION AND NA

=if(iserror(vlookup(...)),0,vlookup(...))

NA and VLOOKUP wrote:

I am trying to use the VLOOKUP function to display the value of zero if it
does not find a reference lookup. Currently if no reference is found it
display #n/a.

--

Dave Peterson

All times are GMT +1. The time now is 05:22 AM.