View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
 
Posts: 60
Default 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