If A1= yes then calculate index

  • Thread starter Thread starter Arno
  • Start date Start date
A

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
 
Arno,

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

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

HtH,
JF
 
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(....))
 
Back
Top