<html><head><title>Excel Jeanie HTML</title></head><body>
</body></html>
For H2 & I2 I can match the two to get the value but I want add another item for excel to look up Column B so I want match H2, I2 , J2. How do I add it to this formula
| Excel Workbook | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | Age | Gender | L1 | L2 | L3 | Age | L | Gender | |||||
| 2 | 18 | M | 0 | 0.45 | 0.5 | 18 | l2 | M | 0.45 | ||||
| 3 | 19 | M | 2 | 0.47 | 0.5 | ||||||||
| 4 | 20 | M | 3 | 0.58 | 0.5 | ||||||||
| 5 | 21 | M | 4 | 0.25 | 0.5 | ||||||||
| 6 | 22 | M | 5 | 0.3 | 0.5 | ||||||||
| 7 | 23 | M | 7 | 0.4 | 0.7 | ||||||||
| 8 | 24 | M | 6 | 0.4 | 0.7 | ||||||||
| 9 | 18 | F | 3 | 0.8 | 0.5 | ||||||||
| 10 | 19 | F | 4 | 0.9 | 0.4 | ||||||||
| 11 | 20 | F | 5 | 0.1 | 0.3 | ||||||||
| 12 | 21 | F | 6 | 1.1 | 0.2 | ||||||||
| 13 | 22 | F | 7 | 1.5 | 0.9 | ||||||||
| 14 | 23 | F | 9 | 1.5 | 0.8 | ||||||||
| 15 | 24 | F | 6 | 0.5 | 0.9 | ||||||||
Sheet | |||||||||||||
</body></html>
For H2 & I2 I can match the two to get the value but I want add another item for excel to look up Column B so I want match H2, I2 , J2. How do I add it to this formula
