One way:

Assume the EO# to search for is in D1. Then array-enter
(CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(A1:A100=D1,B1:B100,""))

In article ,
"asmenut" wrote:

I am trying to place some code that will search 1 column for a number (EO#)
and search it's adjacent cell (Addendum) to find the max number (i.e. there
are 4 rows that each contain an EO# 28609 and their adjacent cells have a
number from 0-3 depending on the row. I need to find a way to search the EO#
column and Addendum column to find the max Addendum for that EO# so that I
can add a new Addendum). I hope this make sense. Any help would be greatly
appreciated.