Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 155
- Office Version
- 365
- Platform
- Windows
Hi, I have index match formula that is returning the correct value, however, I want to add an extra step and if cell 3 says "Plane" I want the value returned to be multiplied by 2 or else if it says "Boat" it is multiplied by 1. In the example I have included it says Plane so should be multiplied by 2.
Any idea how I can add that final piece to the formula?
Thanks
Any idea how I can add that final piece to the formula?
Thanks
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | |||
1 | |||||||||||
2 | |||||||||||
3 | Country/Product | A | B | C | Transport | Boat | |||||
4 | France | €5.00 | €6.00 | €7.00 | Product | C | |||||
5 | Germany | €3.00 | €4.00 | €5.00 | Country | Spain | |||||
6 | Italy | €2.00 | €1.00 | €4.00 | Price | €3.00 | |||||
7 | UK | €5.00 | €5.00 | €5.00 | |||||||
8 | Spain | €1.00 | €2.00 | €3.00 | |||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I6 | I6 | =INDEX($C$4:$E$8,MATCH(I5,$B$4:$B$8,0),MATCH(I4,$C$3:$E$3,0)) |