It kind of sounds like you want to use Data|Validation and maybe dependent
lists.

Try taking a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html

It _might_ be what you're looking for.

Angel aAlegria wrote:

=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE))

col 2 col 3 col
4 col 5 col 6
Absolute Black 12" x 12" tile $3.80 $3.80 $3.80 $3.61 $3.61

In the above formula the number 2 is just showing the price in col 2, i
would like it to show all 5 prices in a drop down list. The prices are on a
separate sheet.

--

Dave Peterson