Hello everyone! I am using this formula to look for a specific value in a range located on a sheet called "CAA"
=INDEX(CAA!BT5:CAA!BT34;MATCH(13;CAA!BS5:CAA!BS34;0))
My question is: since I have a cell named exactly as the sheet, can I use that cell reference to redirect it to the sheet, so that whenever I want to use that sheet I'll just use that cell reference?
Basically what I would like to do is to replace "CAA!" with this particular cell reference.
If this is possible, how would that replacement look like in this formula?
=INDEX(CAA!BT5:CAA!BT34;MATCH(13;CAA!BS5:CAA!BS34;0))
My question is: since I have a cell named exactly as the sheet, can I use that cell reference to redirect it to the sheet, so that whenever I want to use that sheet I'll just use that cell reference?
Basically what I would like to do is to replace "CAA!" with this particular cell reference.
If this is possible, how would that replacement look like in this formula?