I have a spreadsheet where I need a reference to a whole column. The catch is that I don't know which column ahead of the time, so I use
MATCH function to find that out. Once I find the right column I need to reference cells in it.
Two problems stop me from using something simple like
CHOOSE function instead:
- I have couple hundreds of columns that could be referenced
- I need to reference whole column simply, because the amount of rows is varying as well
Originally I was thinking about using
ADDRESS requires me to specify rows as well. Then I thought I could use
CODE, but my formula for columns with multiple letters was buggy.
How do I achieve this? (Reference whole column based on a lookup/match.)