AnsweredAssumed Answered

Price Guide Help

Question asked by bcameron on Apr 17, 2018
Latest reply on Jun 18, 2018 by philmodjunk


Hello,

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.

Outcomes