Hi
I am looking to search two columns that are not side by side to match up to get the answer from a third column that is also not side byt side with either of the first two columns.
In the attachment the data is in B4 to G13, I want to search column B and D to get the answer in column G. For example if I am looking for "b" and "rr" the answer would be 22
Thanks in advance
Six.xlsx
As long as the combinations are unique you can use a SUMIFS function.
I4 = B
J4 = RR
=SUMIFS(G4:G13,B4:B13,I4,D4:D13,J4)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Greg,
Based on user input values for Input1 and Input2, Result is calculated based on the below array formula (confirmed by pressing (Ctrl+Shift+Enter) :Refer enclosed workbook. Is this what you need?Formula:
Please Login or Register to view this content.
Last edited by Saarang84; 07-07-2014 at 09:25 PM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
=INDEX(G4:G13,MATCH(1,IF(B4:B13="f",IF(D4:D13="ee",1)),0))
=INDEX(G4:G13,MATCH("f"&"ee",B4:B13&D4:D13,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks