How to do this formula???

[jimmy]

Hello,

Sheet 1
A1 Classe1 or Class1a or Class2
A2 Result Value
A3 FORMULA?????
(taking in consideration the option in cell A1 - class1,class1a,class2 -
and the result value in cell A2, how to get the match number from Sheet 2 ?
Exp.:
If A1= Class1
If A2= 1,070.00€
Then A3= 1.00
But IF A1=class1a
Then A3= 3.00

But if A1=class2

Then = 5.00

Sheet 2
A B C
D
Classe 1 Classe 1a Classe 2
1,070.00€ 1.00 3.00 5.00
1,075.00€ 1.40 0.00 0.00
1,080.00€ 1.80 0.00 0.00


Thnak you.

jimmy

 

[Mike H]

Jimmy,

Try this

=INDEX(Sheet2!B24,MATCH(A2,Sheet2!A2:A4,0),MATCH(A1,Sheet2!B11,0))

Mike

 

[jimmy]

Hi Mike I

Thanks again!