HLOOKUP Value not available error

Hi all,

I seem to be having trouble with using the HLOOKUP function and i cant understand what im doing wrong.

I simply want to look up max value (number) in a table row and return the header of that column (a text string).

My formula is =HLOOKUP(MAX(A2:H2),A1:H1,1,FALSE)

It just returns #N/A

Am i being really stupid, i have even just tried the HLOOKUP with out the MAX function in it... =HLOOKUP(B2,A1:H1,1,FALSE)
It still returns the #N/A

If i change the formula so that im looking for the Column title and asking it to return a value it works, is it something to do with searching for a number and returning a string?

Thanks

Ross

you need to be able to find the value you're looking up in the range you specify.

Is max(A2:H2) found within A1:H1?

CC

I basically have a list of values.. say city populations in the cell range A2:H2
I then want to return the name of the city with the largest population.

cheers

r

oops i meant to say the range is actually A1:H2 sorry typo

Ross

ah perfect that works a treat.

Thanks for that :D

Ross