G
Guest
I have price tables that are similar to the below
A B C D E F
1 PLN RANGE 1 2 3 4
2 UCP 30000-50000 790 850 950 1500
3 UCP 51000-60000 850 950 1000 1800
4 UCP 61000-70000 900 975 1200 1850
5 UMP 30000-50000 790 850 950 1500
6 UMP 51000-60000 850 950 1000 1800
7 UMP 61000-70000 900 975 1200 1850
ETC
my data looks like this
A B C
1 PLN LVL SALARY
2 UCP 1 65000 so this would return 900
3 UMP 2 35000 and this would return 850
So basically, if C2>=61000, then find UCP on the above table, and then find
the value for level
Make sense?
Many Thanks
A B C D E F
1 PLN RANGE 1 2 3 4
2 UCP 30000-50000 790 850 950 1500
3 UCP 51000-60000 850 950 1000 1800
4 UCP 61000-70000 900 975 1200 1850
5 UMP 30000-50000 790 850 950 1500
6 UMP 51000-60000 850 950 1000 1800
7 UMP 61000-70000 900 975 1200 1850
ETC
my data looks like this
A B C
1 PLN LVL SALARY
2 UCP 1 65000 so this would return 900
3 UMP 2 35000 and this would return 850
So basically, if C2>=61000, then find UCP on the above table, and then find
the value for level
Make sense?
Many Thanks