Hey,
Whats wrong with this formula.
I'm tying to look for value in D3 from array I:L with 3 condition lookup/Match.
Please helpUntitled.png
Hey,
Whats wrong with this formula.
I'm tying to look for value in D3 from array I:L with 3 condition lookup/Match.
Please helpUntitled.png
Try this =SUMPRODUCT(--($I$2:$I$16=A2)*--($J$2:$J$16=B2)*--($K$2:$K$16=C2)*$L$2:$L$16) and pull down as needed
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.Please Login or Register to view this content.
Ben Van Johnson
Thnx, such a help this was
protonLeah Doesn't work when i paste the same to next cell
Last edited by amjad831001; 01-10-2019 at 06:41 AM.
protonLeah Doesn't work when i paste the same to next cell...
Paste?
You are supposed to use the fill handle
Thanx - Proton Leah, i normally press F2 key on the cell of a selected row & then hit return key to copy formulae below. That is why it didn't work, however using fill handle works.
Dont know why
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks