I am trying to use the Indirect formula to be able to reference a different tab when I write in a particular tab.
Here's the formula which works exactly as I intended however I have made it too complex for me to figure out how to insert the Indirect portions!
=INDEX(Pegasys!$D$2:$F$4,(MATCH($B$6,Pegasys!$C$2:$C$4,0)),MATCH(C$6,Pegasys!$D$1:$F$1,0))
I'm referencing a tab called "Pegasys." Let's assume I want to write "Pegasys" in cell A1. How do I insert the Indirect function while leaving my combination of the Index and Match functions alone?
Thank you
Bookmarks