Maybe you could insert another column next to column B in Fclr2.

=if(a3=sheet1!b3,b3,false)
or
=if(a3=sheet1!b3,--b3,false)

drag down the column and do
=max(FLCR2!$c$3:$c$3786)

Heck, that might be worth doing just to see if you find a problem.

=====
And just to double check, you are hitting ctrl-shift-enter with those formulas,
right?



Tenacity wrote:

Is there a way of combining my formula, which works, with your MAX concept in
the same formula so it returns the highest of the matched cells? I can't
figure out how to do that. Thanks for your help.

"Dave Peterson" wrote:

Sorry, I don't have another guess.
<<snipped