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 combinati...
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
It would seem, that somehow, the values are picking up the next column other than intended: I really don't understand how come.
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)/1000HansVogelaarIt worked!!!! Thank you!!!