HLOOKUP function help

  • Thread starter Thread starter T.J.S.
  • Start date Start date
T

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.
 
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)
 
Thanks.
After I looked at what you said I just realized how
stupid that question was. Thanks Again, T.J.
 
Back
Top