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