Forum Discussion
Auto Calculate Data
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. ...
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 |