Hi all,

I have a list of references in column A (1,2,3,4,5)
I have a list of values in column B (15,20,30,15,25)

I want to type into a cell 2 or 3 references and in another the largest of the corresponding values is shown.

example, typing 1,3,5 would give an answer of 30.

Any idea?