Hi,
I have a table of figures that use the HLOOKUP function. The table starts on column C3 and continues to AE6. However, when I use the HLOOKUP I get #NA in the calculated cell. The formula that I am using is:
=HLOOKUP(COUNT($C$3:$AE$3),$C$3:$AE$5,2,FALSE)
Table of Data
Weeks 1 2 3 4 5 6 7 8 9 ...n
L2 2 2 2 2 3 4 5 6 7 8 ...n
L3 3 6 91 11 11 14 13 ...n
Sum 5 8 93...n
So. Where am I going wrong?
I have a table of figures that use the HLOOKUP function. The table starts on column C3 and continues to AE6. However, when I use the HLOOKUP I get #NA in the calculated cell. The formula that I am using is:
=HLOOKUP(COUNT($C$3:$AE$3),$C$3:$AE$5,2,FALSE)
Table of Data
Weeks 1 2 3 4 5 6 7 8 9 ...n
L2 2 2 2 2 3 4 5 6 7 8 ...n
L3 3 6 91 11 11 14 13 ...n
Sum 5 8 93...n
So. Where am I going wrong?