Hello,
I am trying to create a "generatable" INDEX MATCH MATCH formula from cells on different workbooks. I have 3 cells where I can enter the sheet names where the INDEX MATCH MATCH is to take place. I am really trying to avoid using INDIRECT, since I would be using the generated formula on the desired cells, then deleting the cells the generated formula came from.
On the attached, what is shown for the "Final Formula" is exactly what I want to use for the formula, not what the formula itself is (the ="=...stuff).
The purpose is to be able to change the 3 desired sheets and have the already-crafted, long INDEX MATCH MATCH formula created that you just need to paste into a different cell.
I'm happy to clarify, and thank you for any assistance.
-bbkdude
Bookmarks