| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula using INDIRECT function?
Hi,
Can someone help me translate the following formula? =VALUE(IF(ISERROR(INDIRECT(U61&$V$61&MATCH($B$60,I NDIRECT(U61&"A:A"),0))),0,INDIRECT(U61&$V$61&MATCH ($B$60,INDIRECT(U61&"A:A"),0)))) U61 = Belgium! V61 = h B60 = Low If I can understand what it means I may be able to work out what is going on on a very complicated spreadsheet i have inherited... Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula containing the INDIRECT function | Excel Worksheet Functions | |||
| Name of named formula used in an INDIRECT function | Excel Worksheet Functions | |||
| Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Cell value in a formula -- Indirect function? Help please... | Excel Programming | |||
Threaded Mode
