On Wednesday, October 24, 2012 3:55:31 PM UTC-4, Hans Hamm wrote:
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)))))"

I should have added when I try this with formulas for all columns I exceed the # Excel will allow...