IFerror(IF(Hlookup) formula question -- showing an N/A

[McNeil87]

Hello!

I have never used an Hlookup before, but assume it's like a Vlookup, but horizontally looking up a value.

This is the formula: IFERROR(IF(HLOOKUP(TRUE,AU4:BH4,1,0)=TRUE,TRUE,FALSE),FALSE). I am not sure how to interpret this formula.. can someone help explain it to me? Essentially the True/False is returned.

When it returns the value as False, it works, but I notice in the function arguments, it returns an #N/A. Attached an image to show.

Thank you!

Bridget

 

[chipsworld]

Are you trying to look up the value "TRUE"? Looks like your total function is looking to see if a value equals "TRUE" and if so, return the value "TRUE" else return "FALSE")

Typically the "LOOKUP" either V or H is setup as (Lookup value, range to look in, row/column to return from, true/false)
THe response you are receiving is from the IFERROR, not the HLOOKUP

 

[McNeil87]

Correct. Looking up TRUE. The look up looks up true or false statement for both returned values as true, plus formulas to return text.

 

[Fluff]

The #N/A is because the Hlookup couldn't find TRUE in AU4:BH4.
Your formula can be simplified to
=IFERROR(HLOOKUP(TRUE,AU4:BH4,1,0),FALSE)