forginganewone
Board Regular
- Joined
- Mar 14, 2018
- Messages
- 64
[FONT="]Lets assume i have sheet names in cell A1,B1.C1.D1 and my required data can be in any of those sheets.[/FONT]
[FONT="]What i want to do is make index match formula search on all 4 of those sheets on 2 criteria picking from A2 and A3.[/FONT]
[FONT="]I can even tell that A2 criteria values will be in column D of those sheets and A3 criteria values will be in column A of those sheets.
P.S. The list sheet names in A1,B1,C1,D1 are already derived from an array formula.[/FONT]
[FONT="]What i want to do is make index match formula search on all 4 of those sheets on 2 criteria picking from A2 and A3.[/FONT]
[FONT="]I can even tell that A2 criteria values will be in column D of those sheets and A3 criteria values will be in column A of those sheets.
P.S. The list sheet names in A1,B1,C1,D1 are already derived from an array formula.[/FONT]