How to lookup for maximum value of a table with duplicate entries?

[yabi100]

I have a two-column table, called Tbl1. First column called Number and 2nd value.

There are duplicate Numbers in first column.

In a separate column, I have lookup numbers. I want to lookup these numbers in Tbl1 and return max value of second column from Tbl1. If first column of Tbl1 consists of only unique value, that was a standard vlookup. But when lookup values are not unique, I don't know how to solve it? Is it possible?

 

[Legacy 143009]

This may work for you:,

=MAX(IF(LookUpNumbersColum=LookUpValue,MaxValueColumn))

This code won't work if you hit Enter only after input. This is an array formula so you should press Ctrl+Shift+Enter together.

 

[yabi100]

MAX(IF(LookUpNumbersColum=LookUpValue,MaxValueColumn))

Dear Flashbond
Hi. What a beautiful formula. You are a genious. Thanks a lot.

 

[Legacy 143009]

Your welcome! Please mark the solution as answer if it worked for you

 

[yabi100]

Your welcome! Please mark the solution as answer if it worked for you

Dear Flashbond
Sorry I was unaware of that icon. I did it and learned it from you.
Thanks again for all your support and help.