LinkBack URL
About LinkBacks
I am looking to create a pricing sheet with a drop down box that automatically updates with a price in the next column.
I.E
Painter £50
Decorater £70
Dulux white paint £4.50
Hoping someone can explain to me the easiest way to do this.
Many thanks!
I am looking to create a pricing sheet with a drop down box that automatically updates with a price in the next column.
I.E
Painter £50
Decorater £70
Dulux white paint £4.50
Hoping someone can explain to me the easiest way to do this.
Many thanks!
Hello
You would need to create a price list table as per your example. You could then use a Data Validation drop down list in one cell and in the adjacent cell a VLOOKUP function to return the price based on the item selected from the list. See the attached basic example.
DBY
Last edited by DBY; 11-13-2015 at 01:21 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks