| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Array Help in VBA
I am much better with formulas than VBA so, I tried this formula inside VBA.... without {} it does not give me the correct data, with {} VBA fails.
This is one part of the formula, the same formula repeats 11 times looking at different columns for new project data Does anyone have a work around?? =IF(Z3=""N/A"","""",IF(Z3=""OOS"",Z$1&""-""&""OOS"",Z$1&""-""&IF(ISERROR(INDEX(Sheet3!$N$2:$N$10000,MATCH(1,( $A3=Sheet3!$C$2:$C$10000)*(Sheet4!Z$1=Sheet3!$B$2: $B$10000),0))),Z3,INDEX(Sheet3!$N$2:$N$10000,MATCH (1,($A3=Sheet3!$C$2:$C$10000)*(Sheet4!Z$1=Sheet3!$ B$2:$B$10000),0)))))" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| copy one array formula to an array range | Excel Programming | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Threaded Mode
