Hi

What do you mean when you say it doesn't work?
Does it give an answer - but no the answer you expect?
Does it give an error value?

Jarek's suggestion is correct, for the question you asked.
If the formula were entered in say cell A10 of Sheet1, then it would return
the value from Row 11 of Sheet4, for the Column value that appears in Row2
of that sheet, which matches the value in Cell L3 of Sheet1

Can you post a small sample of the data on Sheet4, and what you have entered
in L3

--
Regards
Roger Govier

"willemeulen" wrote in message
...

Jarek Kujawa;350460 Wrote:
=HLOOKUP(L3,Sheet4!B2:AE35,ROW(),FALSE)

Does not seem to work Kajawa :(


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile:
http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98040