Thread: #VALUE! error nesting IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fastballfreddy
 
Posts: n/a
Default #VALUE! error nesting IF function

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
A65:A95

What I came up w/ for cell A2 was

=IF(A1="a",A65),IF(A1="b",B65),IF(A1="c",C65),IF(A 1="d",D65),IF(A1="e",E65),IF(A1="f",F65),IF(A1="g" ,A65)

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

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=540116

Reply With QuoteReply With Quote