What is "extra bits"doing in formula?

  • Thread starter Thread starter Mike Hyndman
  • Start date Start date
M

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
 
Hi Mike:

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

Regards,

Vasant.
 
Hello Vasant

Many thanks for clearing it up 8-)
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.
Click to expand...

remove _bats_ to reply
 
Back
Top