=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.

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

Yes but i need to a list to show up. I want all the prices to show up.

"Dave Peterson" wrote:

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