Formula for a new range.....

[mrmagoo]

Let me see if I can explain.....

I have worksheet No 1 (called codes) with a list of numbers 1,2,3 etc though
to 10.
On worksheet I have a list of part number that is around 10,000 lines long.
Each part number have a price ranging from £0 to £2000.

From worksheet 1 I need a formula in worksheet 2 showing that if a price is
between £0 and £29 I need the code number "1" inserted in column A. If a
part has a price between £30 and £199 I need a code of "2"
inserting..........and so on down the 10,000 line spreadsheet.

Please help ;-)

Hope this is clear.


TiA

[Don Guillett]

You may be making this harder than it needs to be. What do you intend to do
with the 1's and 2's. More detail of your overall plan.

--
Don Guillett
SalesAid Software
[email protected]
"mrmagoo" <[email protected]> wrote in
message news:[email protected]...
>
> Let me see if I can explain.....
>
> I have worksheet No 1 (called codes) with a list of numbers 1,2,3 etc
> though
> to 10.
> On worksheet I have a list of part number that is around 10,000 lines
> long.
> Each part number have a price ranging from £0 to £2000.
>
> From worksheet 1 I need a formula in worksheet 2 showing that if a
> price is
> between £0 and £29 I need the code number "1" inserted in column A. If
> a
> part has a price between £30 and £199 I need a code of "2"
> inserting..........and so on down the 10,000 line spreadsheet.
>
> Please help ;-)
>
> Hope this is clear.
>
>
> TiA
>
>
> --
> mrmagoo
> ------------------------------------------------------------------------
> mrmagoo's Profile:
> http://www.excelforum.com/member.php...o&userid=35238
> View this thread: http://www.excelforum.com/showthread...hreadid=550130
>