G
Guest
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,FALSE))
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.
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.