software

I am entering projections on a worksheet
example $100 in cell 1 $200 in cell 2 ect.

I have a chart that states the criteria needed for each amount entered
example $0-$78 = 1
$79-200= 2
ect ect.

i need a formula where i can enter the projections in one cell and
based on those projections and the chart give the number for those is
this possible--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=502952pooh

Don't know how far ect.(sic) extends, but here is a formula you can adjust.

=LOOKUP(A1,{0,79,201},{1,2,3}) entered in B1

Drag/copy down B as far as you wish.Gord Dibben MS Excel MVPOn Thu, 19 Jan 2006 10:55:31 -0600, darkbearpooh1
gt; wrote:

gt;
gt;I am entering projections on a worksheet
gt;example $100 in cell 1 $200 in cell 2 ect.
gt;
gt;I have a chart that states the criteria needed for each amount entered
gt;example $0-$78 = 1
gt;$79-200= 2
gt;ect ect.
gt;
gt;i need a formula where i can enter the projections in one cell and
gt;based on those projections and the chart give the number for those is
gt;this possible
That works perfect Thanks So Much! I have more work To do to the
worksheet so i might be posting again shortly thanks!!!!!--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=502952