Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

XLOOKUP returning many columns

Revision card: XLOOKUP returning many columns. Example data table with All three marks for Amir: 70, 80, 90; City and Maths (far apart): Pune, 70; Pick columns by number: Amir 80; Zoya 75.

Revision card: XLOOKUP returning many columns. Example data table with All three marks for Amir: 70, 80, 90; City and Maths (far apart): Pune, 70; Pick columns by number: Amir 80; Zoya 75.
Card 1 of 2: XLOOKUP returning many columns · Download PNG
Read card text

What this card says

XLOOKUP returning many columns

Example

data table with All three marks for Amir: 70, 80, 90; City and Maths (far apart): Pune, 70; Pick columns by number: Amir 80; Zoya 75

Learn this in the lesson: Return Multiple Columns with XLOOKUP, HSTACK and CHOOSECOLS in Excel

See all Excel revision cards