match to colums vlookup
 

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.

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