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