Excel formula to use to compare value in sheet column a&b to sheet 2 column a&b if equal get the value in sheet 2 column c?
-
sheet 1 column a column b column c 4589 big 80 sheet 2 column a column b column c 9865 big 90 678 small 2 9874 large 56 4589 big 80 7849 ...show more
-
Answer:
sure, i opened up a new sheet and dropped in your sample. i expanded it to 9 rows to test in sheet 1 cell C1 copy&paste this =SUMPRODUCT(( Sheet2!$A1:$A9=A1)*( Sheet2!$B$1:$B$9=B1)*( Sheet2!$C$1:$C$9)) then change A1 and B1 randomly to test add stuff to sheet 2 on your real sheet, when you change the ranges....make sure that all 3 columns are the same # of rows. let me know how it works for you.
SAS6XU5MF2XFSKSMRD5LQECSHE at Yahoo! Answers Visit the source
Related Q & A:
- What jobs can you get with a B. in Commerce?Best solution by Yahoo! Answers
- How do i isolate a in p=a+b+c?Best solution by Yahoo! Answers
- What is the difference between Hepatitis A, B & c?Best solution by Yahoo! Answers
- Can I get a masters in environmental science if I have a B.A. in political science?Best solution by Quora
- Can I get an MBA with my 2 B.A's in?
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.