# Re: #VALUE! error nesting IF function

 Subject: Re: #VALUE! error nesting IF function Posted by: Biff (biffinpi…@comcast.net) Date: Mon, 8 May 2006

Hi!

This will work as a replcement for your formula:

=INDEX(A65:G65,MATCH(A1,{"a","b","c","d","e","f","g"},0))

But I have no idea what your tying to do with this:

> 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

Biff

"fastballfreddy"
<fastballfreddy.27iqny_1147141801.1655@excelforum-nospam.com> wrote in
message news:fastballfreddy.27iqny_1147141801.1655@excelforum-nospam.com...
>
> 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(A1="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?action=getinfo&userid=33986