How about

=IF(Data!A2=All1,All1,"")&IF(Data!A2=All2,All2, "")&etc.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Amy" wrote in message
...
Hi all,

I have used Chip Pearsons work around for nested ifs. I have named my 6
separate formulas All1 - All6. But the 'Master' formula does not seem to
work. I am trying to do something like
=IF(Data!A2=All1,All1,IF(Data!A2=All2,All2, etc.

Any help greatly appreciated.