Trying to create a pricing database, and thought it was fairly straightforward but having a problem.
12 individual quality groups.
Each group contains 22 to 29 items of minimum and maximum size, and a price that corresponds to that size.
I created a table that contains the Group name, min. size, max. size and price. Created another table for a pricing worksheet to enter Group Name, actual size. Relationship Group name between the two table.
I've tried every formula I could think of, yet I only get the price of the smallest item when I enter a size.
Any help/guidance would be appreciated.