Actually 2 issues, but here is the most pressing:
=HLOOKUP(E3,$AV$5:$CC$7,3,TRUE)
...works fine as long as the value spec'd in (E3) exists in the table. If not, then I get some (seemingly) random value, which is unacceptable.
So I tried this:
=IF(H3,(HLOOKUP(E3,$AV$5:$CC$7,3,TRUE)),"")
...works fine in my test sheet but I get #VALUE! in my live project?? The "IF(H3" is referring to a text value cell (not the result of any formula).
So A) any thoughts on the #VALUE! error
and B) is there a better (preferred) way to do this rather than HLOOKUP
thankssssss
=HLOOKUP(E3,$AV$5:$CC$7,3,TRUE)
...works fine as long as the value spec'd in (E3) exists in the table. If not, then I get some (seemingly) random value, which is unacceptable.
So I tried this:
=IF(H3,(HLOOKUP(E3,$AV$5:$CC$7,3,TRUE)),"")
...works fine in my test sheet but I get #VALUE! in my live project?? The "IF(H3" is referring to a text value cell (not the result of any formula).
So A) any thoughts on the #VALUE! error
and B) is there a better (preferred) way to do this rather than HLOOKUP
thankssssss