Hi there,
I'm trying to create an Excel spreadsheet to house all our parts/products for our building company.
I have set up in name manager 'Building Products' and then used data validation to create a drop down list of products under that category...
...the problem is, each item under the name 'Building Products' has a different price and a different quantity (ie: each, box, per meter).
Any advice on filling in the blanks? I think it needs a CHOOSE or VLOOKUP function....
Thanks in advance, Matthew Tingle
Bookmarks