I want to reference entire row from another as argument in my function, normally I would use something like this: OtherSheet!27:27
But what, if 27 is a dynamic value stored in other cell?
For example, I have MATCH function looking like this:
and value 27 stored in cell A1. When I'll change the value to 28 I want my MATCH function look like this:
What should I use to achieve that?