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?
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?