VLookup - HLookup
 

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

VLookup - HLookup
 

There are no salaries between 50,001 and 50,999? (etc)

"Clara" wrote:

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

VLookup - HLookup
 

The table was meant as an example

"Toppers" wrote:

There are no salaries between 50,001 and 50,999? (etc)

"Clara" wrote:

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