Wayne,

I'm not 100% sure what it is you are looking for but possibly you could
use the CHOOSE function to get the results you need. Try something
like,

=CHOOSE(A1,What you want to do if A1=1,What you want to do if A1=2)

A1 is your feature in Sheet2 of your example.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=558904