Hi, I'm still getting used to using these and i'm trying to adapt previous code to fit my needs, but I don't really understand how.
For this scenario, I have 3 sheets (Sheet1, Sheet2, Sheet3). I have named ranges on sheet1.
How do I transfer this to Code? I'm trying not to use .FormulaArray
Is there an easier way to to say combine the last 2 arguments and use Data7 for D7:D8? i use a variation of this formula in another column where I want Data1 to pull if Data6 equals D7 or D8?
This formula is in column A of sheet 2.
this is the array formula I'm using:
=INDEX(Data1,MATCH(1,(Data2=$E3)*(Data3=$O3)*(Data4=$J3)*(Data5=$I3)*(Data6<>Sheet3!D7)*(Data6<>Sheet3!D8),0))
For this scenario, I have 3 sheets (Sheet1, Sheet2, Sheet3). I have named ranges on sheet1.
How do I transfer this to Code? I'm trying not to use .FormulaArray
Is there an easier way to to say combine the last 2 arguments and use Data7 for D7:D8? i use a variation of this formula in another column where I want Data1 to pull if Data6 equals D7 or D8?
This formula is in column A of sheet 2.
this is the array formula I'm using:
=INDEX(Data1,MATCH(1,(Data2=$E3)*(Data3=$O3)*(Data4=$J3)*(Data5=$I3)*(Data6<>Sheet3!D7)*(Data6<>Sheet3!D8),0))