What formula should I use if I were to search up with a specific criteria to return a value?-CodePudding

Home > Software design > What formula should I use if I were to search up with a specific criteria to return a value?

What formula should I use if I were to search up with a specific criteria to return a value?

Time：11-07

Example sheet link :

and:

=INDEX(IFNA(VLOOKUP(I8:I, B3:F, IF(J8:J=C2, {2, 4}, {3, 5}), 0)))