Help with Function

  • Thread starter Thread starter Grant Reid
  • Start date Start date
G

Grant Reid

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
 
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))
 
Back
Top