Try the following array formula:
=MAX((A1=Sheet2!A1:A5)*(B1=Sheet2!B1:B5)*Sheet2!C1:C5)
Adjusting the ranges "A1:A5", "B1:B5" and "C1:C5" to the respective ranges
on sheet2.
Just to remember, to use an array formula you should paste the code and then
press CTRL+SHIFT+ENTER (if you just press ente
I have a sheet that has 2 columns of data. The second sheet has those same
columns and another column. I need the max of sheet 2 col C if:
Sheet 2 col A contains sheet 1 cell A2 AND
Sheet 2 col B contains sheet 1 cell B2.
Sheet 1:
Col A Col B Col C
AB1
