Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with complex formula
Is it possible to write a formula that uses the input from cell H5 and
compares it to the various ranges of values in B6:C23 and if matched, returns the value in column D to cell H6? Data table: A B C D E F G H 5 From To % Used Input: 2.16 6 $1.91 $1.95 15% % Used: 7 $1.96 $2.00 16% 8 $2.01 $2.05 17% 9 $2.06 $2.10 18% 10 $2.11 $2.15 19% 11 $2.16 $2.20 20% 12 $2.21 $2.25 21% 13 $2.26 $2.30 22% 14 $2.31 $2.35 23% 15 $2.36 $2.40 24% 16 $2.41 $2.45 25% 17 $2.46 $2.50 26% 18 $2.51 $2.55 27% 19 $2.56 $2.60 28% 20 $2.61 $2.65 29% 21 $2.66 $2.70 30% 22 $2.71 $2.75 31% 23 $2.76 $2.80 32% TIA, Steve Weaver |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with complex formula
Hi Steve,
=VLOOKUP(H5,B6:D23,3) -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve B" <Steve wrote in message ... Is it possible to write a formula that uses the input from cell H5 and compares it to the various ranges of values in B6:C23 and if matched, returns the value in column D to cell H6? Data table: A B C D E F G H 5 From To % Used Input: 2.16 6 $1.91 $1.95 15% % Used: 7 $1.96 $2.00 16% 8 $2.01 $2.05 17% 9 $2.06 $2.10 18% 10 $2.11 $2.15 19% 11 $2.16 $2.20 20% 12 $2.21 $2.25 21% 13 $2.26 $2.30 22% 14 $2.31 $2.35 23% 15 $2.36 $2.40 24% 16 $2.41 $2.45 25% 17 $2.46 $2.50 26% 18 $2.51 $2.55 27% 19 $2.56 $2.60 28% 20 $2.61 $2.65 29% 21 $2.66 $2.70 30% 22 $2.71 $2.75 31% 23 $2.76 $2.80 32% TIA, Steve Weaver |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with complex formula
Thank you Niek, that did the trick.
"Niek Otten" wrote: Hi Steve, =VLOOKUP(H5,B6:D23,3) -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve B" <Steve wrote in message ... Is it possible to write a formula that uses the input from cell H5 and compares it to the various ranges of values in B6:C23 and if matched, returns the value in column D to cell H6? Data table: A B C D E F G H 5 From To % Used Input: 2.16 6 $1.91 $1.95 15% % Used: 7 $1.96 $2.00 16% 8 $2.01 $2.05 17% 9 $2.06 $2.10 18% 10 $2.11 $2.15 19% 11 $2.16 $2.20 20% 12 $2.21 $2.25 21% 13 $2.26 $2.30 22% 14 $2.31 $2.35 23% 15 $2.36 $2.40 24% 16 $2.41 $2.45 25% 17 $2.46 $2.50 26% 18 $2.51 $2.55 27% 19 $2.56 $2.60 28% 20 $2.61 $2.65 29% 21 $2.66 $2.70 30% 22 $2.71 $2.75 31% 23 $2.76 $2.80 32% TIA, Steve Weaver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex IF formula | Excel Worksheet Functions | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
complex formula? | Excel Discussion (Misc queries) | |||
Complex Formula | Excel Worksheet Functions | |||
complex formula | Excel Worksheet Functions |