Help with Function

Hi

I have a list in my spreadsheet which is extracted from a database and I
need to look up values in this list. The value to lookup may, or may not be
in this list. What I need is a method to report that the value does not
exist, and if it does exist it must return the required info.

This is what I have at the moment

=IF(ERROR.TYPE(MATCH("tempdb data and log",$C$3:$C$100,0))=7,"Insert Seed
Values",OFFSET($C$2,MATCH("tempdb data and log",$C$3:$C$100,0),1))

It returns the "Insert Seed Values" text if a record cannot be matched,
however if the record does exist, it returns #NA. Not sure if this is
relevant, but the lookup value to be returned is numeric.

Frustrating indeed. Any help would be mutch appreciated.

Regards - Grant

Frank
Tue Apr 13 08:16:02 CDT 2004

Hi
try
==IF(ISNA(MATCH("tempdb data and log",$C$3:$C$100,0)),"Insert Seed
Values",OFFSET($C$2,MATCH("tempdb data and log",$C$3:$C$100,0),1))

--
Regards
Frank Kabel
Frankfurt, Germany


Grant Reid wrote:
> Hi
>
> I have a list in my spreadsheet which is extracted from a database
> and I need to look up values in this list. The value to lookup may,
> or may not be in this list. What I need is a method to report that
> the value does not exist, and if it does exist it must return the
> required info.
>
> This is what I have at the moment
>
> =IF(ERROR.TYPE(MATCH("tempdb data and log",$C$3:$C$100,0))=7,"Insert
> Seed Values",OFFSET($C$2,MATCH("tempdb data and
> log",$C$3:$C$100,0),1))
>
> It returns the "Insert Seed Values" text if a record cannot be
> matched, however if the record does exist, it returns #NA. Not sure
> if this is relevant, but the lookup value to be returned is numeric.
>
> Frustrating indeed. Any help would be mutch appreciated.
>
> Regards - Grant