thanks but no, once the 1st condition is satisfied it stops, hence the result I see f0r 40000 is 1450 (as 40000 is greater than 10000 it returns corresponding value and does not look further
Book3.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | 0 | 0 | 23495 | 2300 | |||||
3 | 10000 | 1450 | 12970 | 1450 | |||||
4 | 20000 | 2300 | 98700 | 5200 | |||||
5 | 30000 | 3700 | 45000 | 5200 | |||||
6 | 40000 | 5200 | 8899 | 0 | |||||
Sheet951 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G2:G6 | G2 | =LOOKUP(F2,B$2:B$6,C$2:C$6) |