Thread: Lookup function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LoveCandle LoveCandle is offline
external usenet poster
  
Posts: 1
Default Lookup function

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

Reply With QuoteReply With Quote