Range("D6").FormulaArray = "=INDEX(AF1:AF300,MATCH(B6&CHAR(127)&C6,AD1:AD300&CHAR(127)&AE1:AE300,0),0)"
chad1222 said:Yes, thank you aladdin i finally got something working now.
Now my question is how can i integrate either an IF statement or an IF(ISNA)) into this formula
=INDEX(AF1:AF300,MATCH(B6&CHAR(127)&C6,AD1:AD300&CHAR(127)&AE1:AE300,0),0)
I am actually using VBA to input these into the proper cells and i am using
Code:Range("D6").FormulaArray = "=INDEX(AF1:AF300,MATCH(B6&CHAR(127)&C6,AD1:AD300&CHAR(127)&AE1:AE300,0),0)"
any ideas?
chad1222 said:The reason i am putting the actual forumla in by VBA is because my users sometimes screw the code up. So i have a toolbar that says "Reset code" when this is pushed it deletes all the formulas and reinputs them in the correct cells just as i intended. This button does not get pushed everytime the workbook is opened much less everytime a cell changes. I do not want to have that much code running as each cell is changed that is why i want the formula in the actual cell. Seeing as you do not know VBA just pretend that we are not using it and i am inputing this formula in a cell and i want to suppress the #N/A how can i edit this one line formula to do that and just leave it blank if it does not find a match.
Chad