Forum Discussion
Solved
another match/search and return value challenge
I have a new challenge.
The document is attached for ease of understanding. Basically, I'm trying to retrieve data from the Search tab and return the value in the other tab.
What combination of functions can I use? Thanks (again!).
Sorry, my mistake. It should have been
=SUMIFS(INDEX(Sheet4!$B$13:$K$46,0,MATCH(C$2&C$3,Sheet4!$B$10:$K$10,0)),Sheet4!$A$13:$A$46,$A10,Sheet4!$L$13:$L$46,$A$8&$A$9&C$1)/1000
16 Replies
With the attachment.
In C48:
=SUMIF(Search!$A$2:$A$37,$A48,INDEX(Search!$B$2:$Q$37,0,MATCH(C$2,Search!$B$1:$Q$1,0)))Fill to the right to column F, then down to row 50 (or vice versa).
In H48:
=SUM(C48:F48)Fill down to row 50.
HansVogelaar Thanks for this! It worked again.
Just to add complexity -- I would like to add a 'check' by adding a Total (Row 52) vs =sum function. Filtering the data, I can trust Row 52 -- but now, the 53, 54 and 55 are not following.
