Lookup Multi Vector

[amrane]

Dear Forum,

I would like to get your help for my blocking point,so the attached file is describing my problem:

Input data:


it can be many data, with different value.

Output result:

I must get automatic result, otherwise I have every time to look for very long list, what is the max value;


Amrane

BR,

[zbor]

I didn't quite understand so can you look at the example and tell me what I'm missing?

Edit: Also, sometimes it's good in example to write example of output result aswell

[amrane]

Dear Zbor,


Thx,

Great,

BR,
Amrane