How to do this formula???
 

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

How to do this formula???
 

Jimmy,

Try this

=INDEX(Sheet2!B2:D4,MATCH(A2,Sheet2!A2:A4,0),MATCH (A1,Sheet2!B1:D1,0))

Mike

"jimmy" wrote:

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

How to do this formula???
 

Hi Mike I

Thanks again!

"jimmy" wrote:

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