lookup functions

[Matt]

As far as I know, when using the lookup function, if an
exact match is not found then the closest value in the
list is used.

Is there any way to have your results show as N/A unless
an exact match is found?

thanks,

Matt

 

[BenjieLop]

See if this works for you:

=if(isna("your_formula"),"","your_formula")

 

[RagDyeR]

There are many ways.

Post the formula that you're using so that viable suggestions can be given
to you.
--

Regards,

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

As far as I know, when using the lookup function, if an
exact match is not found then the closest value in the
list is used.

Is there any way to have your results show as N/A unless
an exact match is found?

thanks,

Matt

 

[Ramakrishnan Rajamani]

The formula that BenjieLop has given will work only to
return a NULL when there is "NA" but will not work for an
exact match.