vlookup multiple sheets

[onestar]

Hi All,

I need help, tried many times but can't figure it out.
I have this plist.xls as attached, 5 sheets which is sheet bon, sheet rak, sheet bak, sheet can and sheet1
in sheet1, i have a table, for instance I want to type in description: "bon" then the description will have selection for the size etc. and price auto come out in column price.
Do I have to use vlookup or any other way?

Please advise..

Thanks

[Richard Buttrey]

Hi,

It's not clear to me what you mean.
Your items are not unique so what prices do you expect to pick up. As minimum each row on your 5 sheets should have a unique item number.

Please add some typical results so that we can see what you expect to see.

[onestar]

Hi,

actually the intention to comparing the price between companies.
if I type the description for instance: bon in cell B4, then B5 display the selection of the size, and in price column will display the comparison pricelist so I can select which one is cheaper.
Do I need to submit to other forum instead of General Forum?