Forum Discussion
Sorting a spreadsheet that uses data validation in a couple of columns.
Input sheet: "Data" tab Output sheet: "2023–24 Platinum Club" tab I'm working with an output spreadsheet that's pulling data from an input spreadsheet in the same workbook. Some columns on th...
TaraMayFlanagan There are a number of things I would do differently with this spreadsheet; however, to deal with the question at hand, try using either one of the following lookup formulas as the data validation list source:
=INDEX(Data!$K$4:$O$1000, MATCH(C4, Data!$C$4:$C$1000, 0), 0)
- OR -
=XLOOKUP(C4, Data!$C$4:$C$1000, Data!$K$4:$O$1000)
The formulas shown above will return the corresponding row (from column K thru O on the "Data" worksheet) where the "Member" number is found in column C.
Note: if the XLOOKUP function is not available in your version of Excel, use the INDEX / MATCH method instead.