I am using lookup function properly (I think).

Problem: If the lookup value is in the lookup vector no problem.

But if the lookup value is not in the lookup vector...it gives a lookup
result... HOW?

Any help?


Steve

If Lookup() can't find the exact lookup value, it matches the largest value
in the lookup vector, that is less than or equal to the lookup value.

That's how come you're receiving a return.

You should perhaps be using Vlookup() or the Index() and Match()
combination.

Post back with your present formula if you would care for some suggestions,
using the other functions.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


"seve" wrote in message
oups.com...
I am using lookup function properly (I think).

Problem: If the lookup value is in the lookup vector no problem.

But if the lookup value is not in the lookup vector...it gives a lookup
result... HOW?

Any help?


Steve

RD,

Thanks for you advice, I was in the process of investigating vlookup
and finally made it work.

Many thanks for your advice.

Steve

You're welcome!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"seve" wrote in message
ups.com...
RD,

Thanks for you advice, I was in the process of investigating vlookup
and finally made it work.

Many thanks for your advice.

Steve

There is no reason to abondon LOOKUP if the lookup table is in ascending
order...

seve wrote:
RD,

Thanks for you advice, I was in the process of investigating vlookup
and finally made it work.

Many thanks for your advice.

Steve

OP is looking for an exact match Aladin, as construed in the third line of
the OP.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Aladin Akyurek" wrote in message
...
There is no reason to abondon LOOKUP if the lookup table is in ascending
order...

seve wrote:
RD,

Thanks for you advice, I was in the process of investigating vlookup
and finally made it work.

Many thanks for your advice.

Steve

=IF(LOOKUP(LookupValue,$F$2:$F$100)=LookupValue,LO OKUP(LookupValue,$F$2:$G$100),"")

where F2:G100 is the lookup table, sorted on F2:F100 in ascending order,
will perform better than:

=VLOOKUP(LookupValue,$F$2:$G$100,2,0)

or

=IF(ISNA(VLOOKUP(LookupValue,$F$2:$G$100,2,0)),"", VLOOKUP(LookupValue,$F$2:$G$100,2,0))

Ragdyer wrote:
OP is looking for an exact match Aladin, as construed in the third line of
the OP.