Greg wrote:
Hi,

Lookes like this question should be in a Functions group.

Why can't you lookup the sale price ?

Say items are in Col A, Quantity in Col b , so in C lookup the price for
each item and then in col D do B2*C2. If the items are not unique you could
get subtotals by using Sumif or better yet Sumproduct functions (search
functions group).

Never knew that a functions group existed until now. Thanks for you
help