Find the last-row result of multiple matches?

@snb, yes, I think that is similar to OP's original formula (MAX rather than LARGE), however, you need to adjust either your use of ROW or initial INDEX range - as is you are offsetting by 1 row.

@DO

Sure !
I amended the code. (I overlooked that because I tested on my system using F1:F3000).

Originally Posted by DonkeyOte

@snb, yes, I think that is similar to OP's original formula (MAX rather than LARGE),.......

There is a difference, though, if there are no rows that meet the criteria. MAX will return zero and LARGE will return an error. The former is a problem because when the zero is fed to the INDEX function the whole column is returned. Here because only a single value can be returned by the formula that manifests itself as the contents of G2 - hence an erroneous result.......better to get the error with LARGE.......

wouldn't this suffice ?

PHP Code: 

=if(countif('[fileB.xls]Sheet1'!$F$2:$F$3000,B3)=0,"",INDEX('[fileB.xls]Sheet1'!$F$2:$G$3000,MAX(IF('[fileB.xls]Sheet1'!$F$2:$F$3000=B3,ROW($F$2:$F$3000)-1,0)),2))