G’Day
I am looking for a way to create a “Look up” that will return more then one figure.
I have a table that has 400 rows and 50 columns and I would like my look up to return the entire line of 50 figures.

I currently use 50 individual Vlookup’s

The Vlookup parameters change according to what the user wants to see via concatenated cells.


Thanking you,

Michael