Need function to find row and column based on cell values

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.

Please Login or Register  to view this content.

This is giving an error , could you help me figuring out what I'm doing wrong please?

Originally Posted by JBeaucaire

I would think:

=INDEX(RESUMO!$D$27:$EA$4000, MATCH(AMOSTRAS!B4;RESUMO!$C$27:$C$4000; 0), MATCH(AMOSTRAS!K7;RESUMO!$D$26:$EA$26;0))

It is still giving an error message and highlighting in black

Please Login or Register  to view this content.