HLOOKUP

[lieven]

Hi,

a silly question: why doesn't this work?
=HLOOKUP(N7;N935;11;FALSE)
I want to search the array N935 for the value of cell N7.

Thanks,

Lieven

 

[Jacob Skaria]

Formula syntax is correct. If a match is found in the first row of the array
(row 9) then the formula returns the corresponding value from 11th row of the
array which is row19

 

[Ray]

What do you mean by "doesn't work"? Do you get an error message or
the wrong result or ???

If you're getting an #N/A error, there's probably a formatting issue
in play -- for example, N7 is Text, while N99 are Numbers ...