Auto Calculate Data

[Rebecca560]

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.  

[#2]

@Rebecca560 

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