(ask) Vlookup to find max in table list.

**sr_88** · 08-21-2012, 12:37 AM

a 10
a 20
a 30
b 15
b 25
b 35

find max in list
a = should be 30
b = should be 35

what is the vlookup formula ? thx

**dilipandey** · 08-21-2012, 12:52 AM

Hi Sr_88,

Welcome to the forum.

use the below array formula:-

{=LARGE(IF($A$1:$A$6=$D1,$B$1:$B$6,""),1)}

See atttached : max lookup.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

**sr_88** · 08-21-2012, 01:31 AM

Dear Mr DILIPandey,
i use excel 2002, download your file, convert it via zamzar.com (xls)
a = 35
b = #value!

thx for fast reply

**dilipandey** · 08-21-2012, 01:39 AM

You need to enter formula using key combination Ctrl + Shift + Enter.... Thanks

Regards,
DILIPandey

<click on below 'star' if this helps>

(ask) Vlookup to find max in table list.

LinkBack

Thread Tools

Rate This Thread

Display

(ask) Vlookup to find max in table list.

Re: (ask) Vlookup to find max in table list.

Re: (ask) Vlookup to find max in table list.

Re: (ask) Vlookup to find max in table list.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions