Need help with a formula

[brandon-castleton]

Hi there -- thanks in advance for the replies.

I am a designer and I want to create a simple formula for my workbooks to return data for one particular item. For example: I want to create a database of all our marble tiles. When the client makes that selection from a dropdown list, I want the other cells in that row to auto fill in: supplier, photo, our cost, and retail price. There are also two types of tiles -- standard and upgrades. If I select a standard tile, I want to price to be reflected as such. If it's an upgrade, I want the standard price to show up and the upgrade price to determine how much more it will cost.

If anyone can direct me to a tutorial or video that explains a multiple row lookup formula, that would help tremendously.

Thanks!

 

[Aadhi]

Hi,

You can use the Vlookup formula in Excel. For Example, if any of your customer selects XXX product, Vlookup(XXX,Sheets("range),"Destination", True or false. That will bring the appropriate value for the selected product. i hope that will help you....

 

[iamphil26]

http://www.free-training-tutorial.com/function-vlookup.html

http://spreadsheets.about.com/od/lo...2010-vlookup-multiple-values-sbs-tutorial.htm

These should get you started on the basics of using LOOKUP, VLOOKUP, HLOOKUP, INDEX, and MATCH.

If you provide a some more information on how your data is set up, we can provide more information and suggestions on how to go about things.

Hope this helps,

Phil