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.
1 Reply
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
