LinkBack URL
About LinkBacks
In the attached file I have used formula INDEX and MATCH in combination which works in first row of reorganised database but does not work in 2nd row. can anybody help resolve this error?
In the attached file I have used formula INDEX and MATCH in combination which works in first row of reorganised database but does not work in 2nd row. can anybody help resolve this error?
Instead of Index/Match you can use SUMIFS.
Into J2:
Formula:
=SUMIFS($E:$E,$B:$B,$H2,$D:$D,J$1)
drag it right/down as needed.
Capture.JPG
INDEX on range E2:E13 has 12 rows and 1 column and as parameter you give it 5 (result from second match).
Last edited by KOKOSEK; 07-24-2020 at 06:30 AM.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
In J2 entercommitted as an array formula ( With Ctrl+Shift+Enter)Formula:=INDEX($E$2:$E$13,MATCH(1,($B$2:$B$13=$H2)*($D$2:$D$13=J$1),0))
Drag down and right
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks