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
|