Are you looking up the *value* "A2",
Or are you looking up the contents of the cell A2?

Is the data in F2 to F51 sorted in ascending order?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LoveCandle" wrote
in message ...

Hi everybody,

I have a problem with LOOKUP worksheet fucnction .. I used in a range
of 10 cells .. in some of these cells it is returning a correct result
. but in other cells it is returning wrong result.

the formuls I am using is the following:


Code:
--------------------
=LOOKUP("A2",Report!$F$2:$F$51,Report!$H$2:$H$51)
Code:
--------------------


I hope you can help me in this case,


--
LoveCandle
------------------------------------------------------------------------
LoveCandle's Profile:
http://www.excelforum.com/member.php...o&userid=28612
View this thread: http://www.excelforum.com/showthread...hreadid=566441