For help creating a pricing table see Pricing Tables.
How a Pricing Table Returns a Price
User Input 1 will look across Row 1 of the pricing table.
- The value in Row 1 less than or equal and closest to the user input 1 will determine the column to look for the price.
User Input 2 will look down Column A of the pricing table.
- The first value in Column A less than or equal and closest to the user input 2 will determine the row to look for the price.
Example: - Column E is Less than User Input 1 and closest to its value.
- Row 12 is equal to User Input 2.
- This helps us get the final Pricing table price of 15.
Rules of a Pricing Table
- Row 1 must increase from left to right.
- The first value must be a number larger than 0.
- Column A must increase from top to bottom.
- The first value must be a number larger than 0.
If a user input value is greater than the largest value in a row or column, the last value in that row or column will be returned.
Troubleshooting
If the expected lookup value is not getting returned, try deleting a few empty rows and columns after your data set.
Sometimes left over partial data can get left behind and removing this data fix the issue.
You can right click a row or column and select Delete. Deleting 3 to 5 rows and columns typically is enough.