Which formula to use if I were to compare values from multiple columns with corresponding values wit-CodePudding

Home > Enterprise > Which formula to use if I were to compare values from multiple columns with corresponding values wit

Which formula to use if I were to compare values from multiple columns with corresponding values wit

Time：11-05

Example

CodePudding user response：

Try this formula in one of your cells. I included in your worksheet.

=filter(C3:C8,B3:B8=F3,A3:A8=E3)