| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable.columnfields(index) vs Pivotcell.columnitem(index) | Excel Programming | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| Excel 2003 index function does not calculate | Excel Worksheet Functions | |||
| How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
| Macro that hide or unhide and not calculate or calculate | Excel Programming | |||
Hybrid Mode
