VLOOKUP() is probably a better choice rather than using IF().
sfs Wrote:
I have a group of mutually exclusive If statements that I want to
exercise in
a cell. Specifically, if the year is 2005 I want to return one value,
if the
year is 2006, I want to return another, etc. Can't see how to do this
simply
without creating a giant nesting of If statements. Anyone have
suggestions?
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=391032