Try this

=SUMPRODUCT(MAX((A2:A100="company name")*(B2:B100)))

"Gábor" wrote:

Hi,

i have a table with two columns: in column A are five different companies
and in column B are the numbers of outgoing invoices. i would like to find -
maybe by using vlookup function - the highest outgoing invoice nzmber at one
selected company. are there some kind of combination of formulas to solve
this problem?

thx in advance!