Formula dependant on finding one of several text stings in a cell

  • Thread starter Thread starter Mal
  • Start date Start date
M

Mal

Hi,

I need help with the following:

Column A example values:

ITEMS_1999
ITEMS_2000
ITEMS_2001
ITEMS_2002
ITEMS_2003

Column B should set one of 3 values,
A if column A contains one of 1999,2000,2001,2002,2003
B if column A contains 2004
C if column A does not contain any of the year values

I have tried combining IF anf FIND/SEARCH functions, but
nested FIND functions keep returning #VALUE! errors

here is what I tried:
=IF((FIND("1999",A1)),1999,1) which returns 1999 if 1999
found in A1 but nesting this to do FIND for 2000 etc does
not work, any ideas?

Thanks
Mal.
 
Back
Top