What is "extra bits"doing in formula?

[Mike Hyndman]

I've inherited a worksheet that contains the following formula
=IF(A1<>"",HLOOKUP(A1,Table,2),"")
I'm familiar with what the HLOOKUP function is doing but not sure as to
what the IF(A1<>"",(),"") bits are doing, especially as the expression
=HLOOKUP(A1,Table,2)
gives the same result.
TIA
MH
remove _bats_ to reply

 

[Vasant Nanavati]

Hi Mike:

The "extra bits" allow for the possibility that A1 is blank, in which case
HLOOKUP would retrurn an error.

Regards,

Vasant.

 

[Mike Hyndman]

Hello Vasant

Many thanks for clearing it up
regards
Mike H

Hi Mike:

The "extra bits" allow for the possibility that A1 is blank, in which case
HLOOKUP would retrurn an error.

Regards,

Vasant.

remove _bats_ to reply