INDIRECT Question I think

Giganews Newsgroups
Subject: INDIRECT Question I think
Posted by:  s boak (sboak.e…@noritake.com)
Date: Wed, 3 May 2006

Hi Folks:

I have a table that's 3 columns something like this

Model        Qty        Price
AB123          1        $ 10.00
AB123      100        $ 9.10
AB123    1000        $ 8.00
AB125    2500        $ 7.50
BA222          1        $ 6.00
BA222        100      $ 5.50

In most cases, this format is followed . . .
Sometimes however, there is only pricing for 1 pc, or 1 and 100, or
sometimes, 1000 and 2500

What I'd like to have is:

AB123        $10.00    $9.10      $8.00
AB125                                                        $7.50
BA222        $ 6.00    $ 5.50

I'm guessing this might be an INDIRECT function, but I need help on
constructing the formula.

Many thanks.
Steve

Replies