Hello
I am trying to come up with a couple of formulas
Basically I have a summary sheet with lots of samples and different assays for each sample.
I then have another sheet called sample, which works as a more specific way to analize the samples.
Each sample has a number and each assay a designation (i.e: NLT).
I need to come up with some formulas to get the result of an assay done to a specific sample, which will be shown in the sample sheet.
For that, the sample sheet has a Cell called Sample (in which the user inputs the number) and a combobox for the assays .Once the user has written the sample number and selected the assay, the worksheet should get the values for some specific cells by running a sort of a vlookup and a hlookup at once, using the sample number to find the row (lets call it x) and the assay to find the column(lets call it y) (both from the sumary sheet, thus reaching the result in cell (x,y) and copying it to the sample sheet.