Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Lookup
Howdy everyone,
I was wondering if there is a command to ask excel to give me the value $8,990 if % to plan is 100% and compliance falls in 30% Thanks, Peter compliance compliance compliance % to Plan < 25% 25 - 35 % 35 - 40% 80% $70 $6,990 $698,990 90% $80 $7,990 $798,990 100% $90 $8,990 $898,990 110% $100 $9,990 $998,990 120% $110 $10,990 $1,098,990 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Lookup
Use these as your column header values: 0%, 25%, 35%
Then: A10 = 100% B10 = 30% =VLOOKUP(A10,A1:D6,MATCH(B10,A1:D1)) -- Biff Microsoft Excel MVP "PJS" wrote in message ... Howdy everyone, I was wondering if there is a command to ask excel to give me the value $8,990 if % to plan is 100% and compliance falls in 30% Thanks, Peter compliance compliance compliance % to Plan < 25% 25 - 35 % 35 - 40% 80% $70 $6,990 $698,990 90% $80 $7,990 $798,990 100% $90 $8,990 $898,990 110% $100 $9,990 $998,990 120% $110 $10,990 $1,098,990 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format lookup | Excel Worksheet Functions | |||
Conditional Lookup | Excel Worksheet Functions | |||
Conditional Lookup | Excel Discussion (Misc queries) | |||
Conditional Lookup? | Excel Worksheet Functions | |||
conditional lookup | Excel Worksheet Functions |