Hi,
Using this formula to bring in data
=INDEX(Sheet 1'!C$2:C$50,MATCH($B2,Sheet1'!$A$2:$A$50,0))
The issue is…I also need the formula to SUM every repeat instance of the Match category “B2”. The formula will only bring back the numbers for the first instance of “B2”.
How can this be updated to sum if there are repeats of match key?
Last edited by TreeLife; 08-29-2016 at 11:04 AM.
Maybe this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
You get better result on your question if you add a small excel file, without confidential information.
Please also add the expected results manualy in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Your sheet names aren't the same:
Sheet 1
Sheet1
Taking a wild guess...
=SUMIF('Sheet1'!$A$2:$A$50,$B2,'Sheet1'!C$2:C$50)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
See attached example.
The above was a typo
I need the formula to find the data in the list and sum every instance of the match key. The formula is on the 2nd tab.
Thanks.
Try this
Formula:Please Login or Register to view this content.
Originally Posted by AlKey
Try this
Formula:Please Login or Register to view this content.
Would this be applied before the Index Formula or in place of? How is the A:A (Match Key) being identified on the Tab Calc Tab?
Last edited by TreeLife; 08-29-2016 at 10:37 AM.
In place of it. You can run this formula in column next to AJ and see the difference.
This works exactly. I feel bad I missed thisThank you!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks