So I'm currently performing a task in which I needed the combination of a Index, Match, Exact formula. I got the formula to work and it is linking to another spreadsheet which has to remain in its current layout. (Because the export will be delivered in this exact format again in the future)
The problem is that the Index, Match, Exact formula is only part of the solution. My previous strategy was to have an IFERROR function cycle through the possible locations of the desired solutions in correct order. But when I try to implement the CSE function which has to be executed by CTRL, Shift, Enter this does not seem to work. (even if I use " { } " to locate the CSE part of the formula.
Now my question is, is it even possible to nest a CSE formula in a much larger formula containing IFERROR and other excel functions?
Thank you in advance!
Bookmarks