Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
USING VLOOKUP AND HLOOKUP | Excel Discussion (Misc queries) | |||
what are the uses for Vlookup and Hlookup? | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |