VLookup with Multiple Criteria

**bigbavarian** · 03-29-2010, 09:55 AM

Hello everyone,

I am trying to create a sheet that looks up the value using two pieces of information. I have attaches a sample.

Basically I am trying to take the value in column A and Column B compate them to the values in Column A and B in the second sheet and pull back the associated value from Column C.

Thanks for you help.

**NBVC** · 03-29-2010, 09:57 AM

Try:

=SUMPRODUCT(--(Report!$A$2:$A$14=A2),--(Report!$B$2:$B$14=B2),Report!$C$2:$C$14)

copied down

**bigbavarian** · 03-29-2010, 10:03 AM

That works perfectly. Thank you.

**NBVC** · 03-29-2010, 10:11 AM

Remember to please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**bigbavarian** · 03-29-2010, 10:58 AM

Two questions.

How do I mark it as solved?
How do I change my profile so I receive an email when someone posts a reply to my post?

I can usually see this on other forums but it is hiding from me on in this forum.

Thanks

Stephen

**NBVC** · 03-29-2010, 11:04 AM

Originally Posted by bigbavarian

How do I mark it as solved?

Instructions were given in my last post.

Originally Posted by bigbavarian

How do I change my profile so I receive an email when someone posts a reply to my post?

I can usually see this on other forums but it is hiding from me on in this forum.

Thanks

Stephen

To to your User control panel, choose Edit Options.. in the Email Notifications sections, choose from the Subscribed threads section...