If A1= yes then calculate index
 

Hello,

is it possible to write a formula that calculate the index below if A1=yes

=INDEX(Rates!$D$5:$Z$131,MATCH($AG$1,Rates!$D$5:$D $131,0),MATCH(AG2,Rates!$D$5:$Z$5,0))


???Is it possible to write something
like...=IF(A1="yes",=INDEX(Rates!$D$5:$Z$131,MATCH ($AG$1,Rates!$D$5:$D$131,0),MATCH(AG2,Rates!
$D$5:$Z$5,0))


Thank you

Arno

If A1= yes then calculate index
 

Arno,

Please post further details on what you are seeking to accomplish as your
formula looks correct.
--
http://HelpExcel.com




"Arno" wrote:

Hello,

is it possible to write a formula that calculate the index below if A1=yes

=INDEX(Rates!$D$5:$Z$131,MATCH($AG$1,Rates!$D$5:$D $131,0),MATCH(AG2,Rates!$D$5:$Z$5,0))


???Is it possible to write something
like...=IF(A1="yes",=INDEX(Rates!$D$5:$Z$131,MATCH ($AG$1,Rates!$D$5:$D$131,0),MATCH(AG2,Rates!
$D$5:$Z$5,0))


Thank you

Arno

If A1= yes then calculate index
 

Hi Arno,

looks like you just need to remove the = before INDEX to make it work.

HtH,
JF

On 24 Nov, 14:45, Arno wrote:
Hello,

is it possible to write a formula that calculate the index below if A1=yes

=INDEX(Rates!$D$5:$Z$131,MATCH($AG$1,Rates!$D$5:$D $131,0),MATCH(AG2,Rates!$*D$5:$Z$5,0))

???Is it possible to write something
like...=IF(A1="yes",=INDEX(Rates!$D$5:$Z$131,MATCH ($AG$1,Rates!$D$5:$D$131,*0),MATCH(AG2,Rates!
$D$5:$Z$5,0))

Thank you

Arno

If A1= yes then calculate index
 

You may want to return something if A1 is different from Yes, too:

=if(a1="yes",index(....),"not yes")

I find this easier to read:
=if(a1<"yes","not yes",index(....))



Arno wrote:

Hello,

is it possible to write a formula that calculate the index below if A1=yes

=INDEX(Rates!$D$5:$Z$131,MATCH($AG$1,Rates!$D$5:$D $131,0),MATCH(AG2,Rates!$D$5:$Z$5,0))

???Is it possible to write something
like...=IF(A1="yes",=INDEX(Rates!$D$5:$Z$131,MATCH ($AG$1,Rates!$D$5:$D$131,0),MATCH(AG2,Rates!
$D$5:$Z$5,0))

Thank you

Arno

--

Dave Peterson