Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|