I have the following formula in my worksheet:

=IF(ISNA(MATCH(B3,FLCR2!$A$3:$A$3786,0)),"Not
Found",VLOOKUP(B3,FLCR2!$A$3:$B$3786,2,0))

What this does is to find a match for cell B3 on the FLCR2 tab within the
range; if the match is not found "Not Found" is returned; if the match is
found Excel looks up the value in the cell to the right of the match and
returns it to the cell containing the formula.

I need to add an additional parameter. Sometimes, the value in B3 matches
several values in column A on FLCR2 tab. Right now, the formula returns the
cell to the right of the first row in which the match occurrs. I would like
it to return the HIGHEST of the values in the cells to the right of any row
it matches. Note, you can't narrow down in advance the range of the rows it
will match=it must be dynamic in the function.

Is this possible, and what additional parameters must I add into the above
function?

Thanks for your help.