Thread: Lookup function

Lookup only works correctly if your lookup range, in this case Report!$F$2:$F$51, is sorted in ascending order. This formula will also give you the "closest match" (next lowest) if an exact match isn't found.

If you only require exact matches, you can have an unsorted lookup range but you should use VLOOKUP, i.e.

=VLOOKUP("A2",Report!$F$2:$H$51,3,0)

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" <LoveCandle.2brsmi_1154282709.0636@excelforum-nospam.com> wrote
in message news:LoveCandle.2brsmi_1154282709.0636@excelforum-nospam.com...
>
> 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
>

Thank you everybody for your help,

I think the solution for my problem is sorting the lookup range in ascending order.

But, by this way I will have to change my table arrangement which I don't want to.. so I prefered to use another worksheet function/s like:

=IF(ISNA(MATCH(A4,Feuil1!$E$9:Feuil1!$E$67,0)),"",OFFSET(Feuil1!$C$8,MATCH(A4,Feuil1!$E$9:Feuil1!$E$67,0),0))

That formula worked perfectly with my case,

Thank you again,