fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 439
- Office Version
- 365
- Platform
- Windows
With the example table below, i want to put the appropriate value in C3 up to C6 if the criteria is met in the right table. The criteria is : it will match the value of A3 Ex in the right table then once it is located it will use the column "Up" or "Low" depends on the value of B3. Example: the value of C3 should be 4%, C4 will be 4%, C5 is 2% and C6 is 5%. help please
=====================================
=====================================
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
2 | Rate | Criteria | Percentage | Rate | Up | Low | ||||
3 | EX | Low | Ex | 5% | 4% | |||||
4 | VG | Up | VG | 4% | 3% | |||||
5 | G | Up | G | 3% | 2% | |||||
6 | EX | Up | F | 2% | 1% | |||||
Sheet1 |