Vlookup to give back the greater number as result

[Fredbugatti]

As for the Vlookup I need it to return the greater number on sheet 2 for Apple example and it is returning 0.
How can I do that, please see attached for example.

Help is much appreciated.

[oeldere]

C2 =INDEX(Vlookup!$A$1:$B$3,Match(Items!B2,Vlookup!$A$1:$A$3,0)+1,2)

[Fredbugatti]

Would you please be able to send back attachment with the formula ?

[Fredbugatti]

and how can i copy and paste formula down the cells to automatically populate?

[oeldere]

see the attached file.

[Fredbugatti]

How would I let it populate for the rest of the cells since when I drag down the cell it wont populate for Line 2 and so on....

[MrShorty]

Does it have to be VLOOKUP()? It sounds to me like more of a MAX(IF(...)) array function (or MAXIFS() function if you can get Excel 2016).

In a different direction, your sample is pretty small. If it is representative of a much larger database, a pivot table (where the value field setting is max) might be a preferable option.