Forum Discussion
Solved
Vlookup for a price list based on width X height in a table
Hi Everyone Can you please help me with the following issue. We have price lists in the below format that we use to price up our products. Is it possible to create a spreadsheet that would automa...
Thanks! Sorry, should have explained better.
Can this be amended so that I can enter width/drop manually and not simply selected from the drop down lists?
Simply select H2:H3, click Data Validation on the Data tab of the ribbon, and click OK when prompted to remove data validation, then click OK again. But you'll get #N/A if you enter a value different from 1000, 1500 and 2000...
How do I make it work in a way so that I can use any number and not get an error?
I need to be able to price a product of any size and the table to be able to understand which size bracket (both width and drop) it falls into and produce a correct answer.
What would the price be for a width of 700 and a height of 1300?
And for a width of 2700 and a height of 2200?
- 700x1300
Width is less than 1000, so first column, drop is between 1000 and 1500, so second row
Price 250
2700x2200 - unavailable in this table as both width and drop exceed the max parameters