*** Equivalent to VLookup in Excel (Returning a String Value) by Using Expression *** (Simple Question)

[IAMDV]

Dear All,

I have a simple question and I had already searched on the forum without any luck. I hope someone can help me on this one.

Lets say we have table...

Product Sales

A 10

B 12

C 15

If I wanted to refer to the product with maximum sales i,e. 'C' in this example by using an expression (with and without set analysis). This is equivalent to VLookup on Max(Sales) in Excel.

TIA!

Cheers - DV

[IAMDV]

Cheenu - Thank very much for detailed explanation. I took sometime to digest the stuff. Many thanks again for your help.

Cheers - DV