Hi,
I'm trying to create an order form where I will be able to select a client and their information from one sheet pulls through and the pricelist associated with them's information pulls through on the products on the order form.
I have no idea how to achieve this, if you could please assist. Attached is our spreadsheet. Order form workbook
Hello,
What Excel version are you using? As you use the old .xls file extension I suspect you might use an old version.
In general, to find the price list for the customer you can use any lookup function, for example VLOOKUP.
Example: =VLOOKUP('Order Form'!A1,'Customer List'!B2:H876,7,0)
The result from such lookup is then used for the next lookup to get the price for the products.
But you will have troubles finding the correct price as you need a unique identifier for each product to be certain you get the correct price. I suggest you look into rearranging the price lists into one list (better yet to use a table) and that it is in a tabular data format. The same product identifier need to be used in the order form. Then you are in a better position to get correct lookup results.
Br,
Anders
