Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=VLOOKUP
Hello folks,
Someone from accounts presented me with am interesting VLOOKUP problem (interesting because I don't fully understand Excel). I have a colum of figures from B6 to B38 I want to present the data in D6 to D38 I would like to apply a % from another worksheet F6 to F8. The % to be applied varies depending on the amount in B6 to B38 ** EXAMPLE. B6 to B38 12,191,984 12,497,627 10,854,088 10,628,373 9,950,800 9,667,445 10,129,664 10,308,847 10,629,769 10,413,796 10,358,897 10,367,604 10,673,805 10,274,035 9,977,234 10,277,299 9,910,732 10,104,963 10,318,960 9,952,196 10,079,331 10,197,333 10,355,460 10,362,925 9,802,999 10,005,238 9,986,293 9,166,972 9,513,328 9,927,705 10,279,043 10,059,406 11,169,842 % to be applied. 0 8,499,999 0.45% 8,500,000 9,999,999 0.35% 10,000,000 to 19,999,999 0.25% 20,000,000 to 39,999,999 0.15% Make sense? I know what I want to do in my head but I don't know how to make this VLOOKUP do it. Can someone assisnt me? Thank you :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |