Suppose your quotation table begins with cell A100, and in this cell
you put a catalogue number. Put this formula in B100:

=IF($A100="","",VLOOKUP($A100,$A$2:$C$80,COLUMN(B1 ),0))

Then copy this into C100, and then copy B100:C100 down for as many
rows as you think you might need. You can put other catalogue numbers
in A101, A102 etc and the appropriate data will show in B and C
columns.

Hope this helps.

Pete


On Aug 20, 8:45*pm, ithinkican2
wrote:
We are designing a quotation sheet. The data is derived from a table above on
the same worksheet that has three columns: A - Catalog #, B - Manufacturing
Price and C - Install Price.

Example:
* A * * * * * * * * B * * * * * * *C
Catalog # * * Mfg * * * * Install
A1 * * * * * * * 2,390. * * *1,500.
A2 * * * * * * * 4,304. * * *2,600.
B1 * * * * * * * 2,100. * * * * 500. *

We will be selecting from the Catalog list (with over 50 items in the list)
and need to essentially, AutoFill in the Mfg and Install prices for the item
into the Quotation Sheet. Problem is, Excel 2007 doesn't allow AutoFill of
numbers.

What formula could we use to accomplish this?