=IF(D2=Z2,"No change required",IF(Y2=2005,"Update FA","Internal mapping"))

Best rgds
Chris Lav

"Cheryl B." wrote in message
...
I think I'm close but am off on the structure and/or syntax. I have three
different conditions for which I need three different results. It may be
a
no-brainer for some but it's about to drive me crazy. Can anybody help?

Condition Result
Tag 1 = Tag 2 No Change
Required
Tag 1 < Tag 2 and Year equal to 2005 Update FA
Tag 1 < Tag 2 and Year not equal to 2005 Internal Mapping

Cell D2 = Tag 1
Cell Z2 = Tag 2
Cell Y2 = Year

Substituting elements with cells, it looks like this:

D2 = Z2 No Change Required
D2 < Z2 and Y2 = 2005 Update FA
D2 < Z2 and Y2 < 2005 Map Internally

But I don't seem to be able to get all in one string for one cell ...

Thanks!