If your list of criteria text is very long, or the "rest of the formula"
varies depending on the criteria, then consider using the VLOOKUP function.

Vaya con dios,
Chuck, CABGx3


<eric@innerlith.com> wrote in message
news:1126039812.760465.46700@f14g2000cwb.googlegroups.com...
> Hi all,
>
> Can an IF statement be written referencing a text value? My situation
> is this I have created a list with different text values. I would like
> the statement to check for these values in the list cell THEN once the
> criteria are met apply the rest of the formula. If somebody knows a
> different way to do this I will take any suggestions.
>
>
> Thanks,
>
> Eric H
>