Jun 14 2019 02:19 PM
I would like to be able to plug in a specific sample number and have the corresponding data automatically update to the existing formulas. I've uploaded a mock spreadsheet to assist in the request.
Jun 14 2019 11:59 PM
A simple VLOOKUP will return your desired results. For example. the formula in C9 in the attached file is:
=VLOOKUP(C$1,
DataTable,
MATCH(A9,DataLabels,0),0)
Note the following defined names used in the foregoing formula:
Name | Formula |
DataLabels | =Data!$A$2:$G$2 |
DataTable | =Data!$A$3:$G$7 |