Can you add a Sheet name to a formula?
Can you include the sheet name in a formula? Not reference the Sheet. The Sheet is already referenced in the INDEX/MATCH formula.
I could manually add the sheet name to the formula, but wondering if it's possible for the formula to automatically pick up on the Sheet name.
Help Article Resources
Check out the Formula Handbook template!