HLOOKUP

  • Thread starter Thread starter lieven
  • Start date Start date
L

lieven

Hi,

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

Thanks,

Lieven
 
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
 
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 N9:P9 are Numbers ...
 
Back
Top