Hi

I could use a little help here please, please see attached worksheet

In column Q I want to lookup the descripton in column A based on the max formula in column R it should read Bactosol Hand Glass Wash 1 Ltr P250589

Range Name is summary P2:P6

The formula I tried is =VLOOKUP(MAX(P2:P5),summary,1,0)

Many Thanks

Braddy