Lookup function

L

LoveCandle

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:
 
D

daddylonglegs

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)
 
R

Ragdyer

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?
 
L

LoveCandle

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:


Code:
--------------------
=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,
 
Top