F1: holds CHAMBORD 140X190
G1: holds IZRADA RUKOHVATA

=INDEX(B2:B100,MATCH(F1&G1,INDEX(A2:A100&C2:C100,0 ),0))


"eXecutioner28" wrote:

to get the idea here is what I have:


2-SIDED POCKET 140x200 0,0040 IZRADA RUKOHVATA
CHAMBORD 140x190 0,0071 IZRADA RUKOHVATA
2-SIDED POCKET 140x200 0,0025 REZANJE
CHAMBORD 140x190 0,0035 REZANJE

so this is on one sheet together (there are more of this operations like
"IZRADA RUKOHVATA" and "REZANJE" but you get the idea). Now I want on a new
sheet to create a selection where I select model - CHAMBORD 140x190 and
operation - REZANJE to get value of 0,0035. But also when I choose different
operation for CHAMBORD 140x190 like "IZRADA RUKOHVATA" to get value of
0,0071.

I know only how to do with one MATCH function. With two MATCH functions I
can get anything...

please help