How to Setup a Pricing Table

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.