#VALUE! error nesting IF function

Giganews Newsgroups
Subject: #VALUE! error nesting IF function
Posted by:  fastballfreddy (fastballfreddy.27iqny_1147141801.1655@excelforum-nospam.com)
Date: Mon, 8 May 2006

In A1 I have a formula that can have 7 results: a,b,c,d,e,f,g

In range A65:A95 I have the results I want if "a", B65:B95 results if
"b" and so on.

What I want is if A1=a, then A2:A32 will fill up w/ the range from

What I came up w/ for cell A2 was


I'm getting a #VALUE! error.  What am I doing wrong or is there a
better way to do this?


fastballfreddy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33986
View this thread:http://www.excelforum.com/showthread.php?threadid=540116