Hlookup and limitations?

[Faz]

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?

 

[dan_l]

the formula appears to work. Would you share your workbook?

 

[Hui]

Faz

Make sure the first row is entered as Numbers and not as Text


Also You have posted different numbers of entries in each row in your sample data, although this won't help your error message

 

[Faz]

Dan_I


I can share- how do I get this to you


FAz

 

[dan_l]

Put it up on dropbox or skydrive or something.....

 

[Hui]

Or have a read of

http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[Faz]

Dan_I


The files is in Google Docs link below:


https://docs.google.com/#folders/folder.0.0B90dy-nGE_IUZWY5MzFjZmItZjQ3Yy00ODhiLTgzZDMtNjBkNjk4YmVhMmUy


Happy to discuss

 

[dan_l]

It's empty....