You mean you want to bring back the total sales when the customer and category
match??

If yes:

=index(othersheet!$c$1:$c$10,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

And adjust the range to match your data--but don't use the whole column.

JavyD wrote:

Hello everyone.

It kills me that I fogot this, I've been using Crystal and Access far too
much. Now it eats me alive not being able to remember something so easy.

I have a Customer in A2 and a Category in B2 and a Total Sales in C2, I have
the same lay out in another spreadsheet. I need match the customer and
category in the other spreadsheet and bring it back to the new spreadsheet.
Please help this poor soul.

--

Dave Peterson