LOOKUP DIFFERENTIATION WHERE HAVE SAME NAME IN TABLE

rebelhunter

New Member
Joined
Oct 24, 2002
Messages
11
A B
NAME AGE

1 dan 10
2 john 15
3 shaun 18
4 dan 27
5 craig 35
6 dan 47

How can i use Vlookup to automatically find the figure in column b, row 4 everytime, within the above table, when the position of dan could change, if more names are added, but the above names stay constant and the figures change??

Regards,
Shaun
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

yosi

Board Regular
Joined
May 14, 2002
Messages
67
use index function with match nested in

=index(a1:c50,match(e1,b:b,0),3))

the data table - a1:c50
in cell e1 - enter any name to search
This message was edited by yosi on 2002-10-25 07:19
This message was edited by yosi on 2002-10-25 11:34
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-10-25 07:01, rebelhunter wrote:
A B
NAME AGE

1 dan 10
2 john 15
3 shaun 18
4 dan 27
5 craig 35
6 dan 47

How can i use Vlookup to automatically find the figure in column b, row 4 everytime, within the above table, when the position of dan could change, if more names are added, but the above names stay constant and the figures change??

Regards,
Shaun

How can 'dan' have 3 different ages?
 

rebelhunter

New Member
Joined
Oct 24, 2002
Messages
11
This is an example just to show the logic i am looking for. Basically i want to know how i can direct Vlookup to find figures with the same description next to them, by finding the 1st figure and then direct the function to the next figure with the same description and find the figure next to that??
 

yosi

Board Regular
Joined
May 14, 2002
Messages
67
Aladin mention that Dan has 3 ages
the match formula with 0 at the third argument will find the first one,
if you sort the list by name ( column B ) enter in the third argumant 1 and get the last one.
 

Forum statistics

Threads
1,144,510
Messages
5,724,786
Members
422,579
Latest member
Lekha mohanty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top