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:
Note the following defined names used in the foregoing formula: