Could you tell me if the excel on two groups of data comparison, and the content of the return to the back of the second column data
As shown in figure
I think series 1 match in the series 2, check the corresponding return return value, could you tell me how to do, the warrior thank you

CodePudding user response:

Many Internet search Excel condition query"

CodePudding user response:

Very good, is need, thanks for sharing!

CodePudding user response:

C2=SUMIFS (F, F, D: D, A2, E, E, B2) down, hope to help you,

CodePudding user response:

Thanks for sharing, learning,

CodePudding user response:

You can also use vlookup

CodePudding user response:

You can develop a for my own use