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.