| 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 |
| 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 | |||
Threaded Mode
