Dear all,
I have to find the row number of the first row matching multiple criteria.
Sheet2A:A=Sheet1!$B$1
Sheet2B:B>=Sheet1!$B$2
Sheet2C:C>=Sheet1!$B$3
Sheet2D:D>=Sheet1!$B$4
I can find lots of information about MATCH-INDEX functions, but it is always about looking up a single value.
Any help solving this challenge or sending me to the right thread will be much appreciated.
Bernd
I have to find the row number of the first row matching multiple criteria.
Sheet2A:A=Sheet1!$B$1
Sheet2B:B>=Sheet1!$B$2
Sheet2C:C>=Sheet1!$B$3
Sheet2D:D>=Sheet1!$B$4
I can find lots of information about MATCH-INDEX functions, but it is always about looking up a single value.
Any help solving this challenge or sending me to the right thread will be much appreciated.
Bernd