# LOOKUP DIFFERENTIATION WHERE HAVE SAME NAME IN TABLE

#### rebelhunter

##### New Member
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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### yosi

##### Board Regular
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

##### MrExcel MVP
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?

#### DonkeyOte

##### MrExcel MVP
different dan's perhaps?

#### rebelhunter

##### New Member
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
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.

Replies
14
Views
675
Replies
2
Views
240
Replies
11
Views
481
Replies
9
Views
491
Replies
3
Views
269

1,181,929
Messages
5,932,843
Members
436,865
Latest member
JHusk

### 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.

### Which adblocker are you using?

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

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