If A1= yes then calculate index

[Arno]

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

 

[galimi]

Arno,

Please post further details on what you are seeking to accomplish as your
formula looks correct.

 

[Joshua Fandango]

Hi Arno,

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

HtH,
JF

 

[Dave Peterson]

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(....))