Is there a way to use one of the LOOKUP functions (or a related function) to return data from multiple cells in the same row instead of just one cell? For instance:
If Col A in a table array contains names and column B contains ages and columns C:F contain other personal data; is there a combination of functions that will report the data in columns C:F as well as column B given a lookup value in col A?
If Col A in a table array contains names and column B contains ages and columns C:F contain other personal data; is there a combination of functions that will report the data in columns C:F as well as column B given a lookup value in col A?