Getting cells in data validation drop down

Hi Guys
I have a problem and requesting help here.
My worksheet data structure is as below.
Column A, a long list of products from say A2 through A200.
Column B through Column F contain various prices for the item in that row.
So B2 through F2 will contain prices (different) for product in A2.

I have a drop down (data validation) list at H2 where I select product. I have made a one time list all the products those are in column A (a named range basically)

Now my requirement is, I need a second drop down (data validation) at I2 where it would show all the applicable prices for that product.
Now since the number of products are around 200, I can not and don't want to make individual named ranges for all the product (prices)

Can somebody help?
As far as possible I do not want VB solution.

Thanks in advance

Wow,
This is exactly what I was looking for
Thanks a Ton

By the way, can following be achieved?
1. If there is a blank in product price, OMIT from drop down. Currently the drop down show a blank
Regards

There are no blanks in prices.
You have seeded the product column using character set.
Chr 143 & 144 are the character id for 'blank'. rows 80 & 81.
At the end you also overrun the maximum of the character set (255) rows 193 to 200 showing #VALUE
torachan.

ASCII Characters
ASCII is currently the standard for the relationship between a number value and a character type.
Note: The characters 1-9 & 11-31 (?? 128-159) are not supported by Windows

just a point of reference.
torachan.

Hi,
I must have incorrectly put my problem
What I meant was
If for some products, some prices are blank then is there a way to omit those blanks from the drop down in the earlier solution
So for example a product at A10, there is a price at B10, D10, F10 but C10 & E10 are blank. Now the drop down will show 2 blanks. Is there a way to omit them?
Thanks