HLOOKUP function help

[T.J.S.]

I am using the HLOOKUP function with an IF statement and
at row 400 it stops working and gives me the #REF error.
This is the formula that I am using, Is there any way I
can cut it down to make it shorter and to get it to work
past 400 rows?

=IF(HLOOKUP(Tournaments!$D$4,'Excel - Tee Times'!
$C$1:$AA$400,400,0)=1,HLOOKUP(Tournaments!$D$4,'Excel -
Tee Times'!$C$1:$AA$400,400,0),0)

Thanks, T.J.S.

 

[Frank Kabel]

Hi
for more than 400 rows you have to change the second parameter of your
HLOOKUP formula. So try
=IF(HLOOKUP(Tournaments!$D$4,'Excel - Tee
Times'!$C$1:$AA$1000,1000,0)=1,HLOOKUP(Tournaments!$D$4,'Excel -
Tee Times'!$C$1:$AA$1000,1000,0),0)

To make this shorter try
=--(HLOOKUP(Tournaments!$D$4,'Excel - Tee
Times'!$C$1:$AA$1000,1000,0)=1)

 

[T.J.S.]

Thanks.
After I looked at what you said I just realized how
stupid that question was. Thanks Again, T.J.