excel hlookup formula

Sandy · Oct 26, 2004

where value is not in row one, how do I return a value of zero instead of #N/A

Govind · Oct 26, 2004

Hi Sandy,

Use

=IF(ISERROR(YOUR HLOOKUP FORMULA),0,YOUR HLOOKUP FORMULA)

Regards

Govind.

Frank Kabel · Oct 26, 2004

Hi
=IF(ISNA(your_formula),0,your_formula)

HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right.	1	Feb 27, 2015
Hlookup	0	Aug 28, 2013
Newbie Help - IF Yes No Function	0	Jan 26, 2022
Hlookup, range_lookup parameter	1	Dec 2, 2008
use Hlookup to look up two or more values	5	Apr 17, 2009
Hlookup with Merged cell as look up value	1	Mar 18, 2010
In MS Excel 2003, need to do conditional formating on HLOOKUP	3	Feb 26, 2009
MATCH to return row number not working in HLOOKUP	2	Apr 3, 2009

Ask a Question