Please help me with VLOOKUP AP

A

AP

I am using VLOOKUP for training participants, the problem which I am facing
now on my list I have got few participants with same surname and my VLOOKUP
picks the 1st participant from the list. Any chance that I can have two or
three cells with Vlookup formula and the cells automatically pick the 2nd and
3rd with same surname

two sheets with name platform and participant check

In platform (colomns)
Name, Surname, date of training, venue, etc....

and in the participant check
when I type the Surname of participants it picks from the platform all the
details for the purticular participant.
the formula which I used is =VLOOKUP(B3,Platform!B:X,8,FALSE)
where as B3 I type the Surname PlatformB:X is the range of Data and 8 is the
'first name' colomn on the platformsheet.

In the participant check sheet I wanted:
I was planing, like it to give me an option where once I type the surname it
shows me all first name if any. or on another cell showing that there is
another person with the same surname

Please help me if there is any solution for that


Thanks
AP
 
N

Niek Otten

Look here:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using VLOOKUP for training participants, the problem which I am facing
| now on my list I have got few participants with same surname and my VLOOKUP
| picks the 1st participant from the list. Any chance that I can have two or
| three cells with Vlookup formula and the cells automatically pick the 2nd and
| 3rd with same surname
|
| two sheets with name platform and participant check
|
| In platform (colomns)
| Name, Surname, date of training, venue, etc....
|
| and in the participant check
| when I type the Surname of participants it picks from the platform all the
| details for the purticular participant.
| the formula which I used is =VLOOKUP(B3,Platform!B:X,8,FALSE)
| where as B3 I type the Surname PlatformB:X is the range of Data and 8 is the
| 'first name' colomn on the platformsheet.
|
| In the participant check sheet I wanted:
| I was planing, like it to give me an option where once I type the surname it
| shows me all first name if any. or on another cell showing that there is
| another person with the same surname
|
| Please help me if there is any solution for that
|
|
| Thanks
| AP
|
 
A

AP

Hi Niek,

Thanks for you help, I think I am very close but its giving me an error. I
am sure you will be able to help.

Surname is in Platform!H
Name is in Platform!I

Will you be able to prepare a formula for me, my whole issue is stuck with
this one.

Many thanks
 
N

Niek Otten

It is very important to array-enter the formulas (where indicated); press CTRL+SHIFT+ENTER, not just ENTER.

Follow the steps in the example carefully; it should work.
There is nothing I can add..........

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Niek,
|
| Thanks for you help, I think I am very close but its giving me an error. I
| am sure you will be able to help.
|
| Surname is in Platform!H
| Name is in Platform!I
|
| Will you be able to prepare a formula for me, my whole issue is stuck with
| this one.
|
| Many thanks
|
| "Niek Otten" wrote:
|
| > Look here:
| >
| > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > |I am using VLOOKUP for training participants, the problem which I am facing
| > | now on my list I have got few participants with same surname and my VLOOKUP
| > | picks the 1st participant from the list. Any chance that I can have two or
| > | three cells with Vlookup formula and the cells automatically pick the 2nd and
| > | 3rd with same surname
| > |
| > | two sheets with name platform and participant check
| > |
| > | In platform (colomns)
| > | Name, Surname, date of training, venue, etc....
| > |
| > | and in the participant check
| > | when I type the Surname of participants it picks from the platform all the
| > | details for the purticular participant.
| > | the formula which I used is =VLOOKUP(B3,Platform!B:X,8,FALSE)
| > | where as B3 I type the Surname PlatformB:X is the range of Data and 8 is the
| > | 'first name' colomn on the platformsheet.
| > |
| > | In the participant check sheet I wanted:
| > | I was planing, like it to give me an option where once I type the surname it
| > | shows me all first name if any. or on another cell showing that there is
| > | another person with the same surname
| > |
| > | Please help me if there is any solution for that
| > |
| > |
| > | Thanks
| > | AP
| > |
| >
| >
| >
 
N

Niek Otten

Yes, Dennis, You are right!
That must have happened since I successfully tried these formulas.

They should be:

=SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1))
=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)))
=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)))),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1))))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| The example formulae cut off before completion, that is the problem
|
| "Niek Otten" wrote:
|
| > It is very important to array-enter the formulas (where indicated); press CTRL+SHIFT+ENTER, not just ENTER.
| >
| > Follow the steps in the example carefully; it should work.
| > There is nothing I can add..........
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Hi Niek,
| > |
| > | Thanks for you help, I think I am very close but its giving me an error. I
| > | am sure you will be able to help.
| > |
| > | Surname is in Platform!H
| > | Name is in Platform!I
| > |
| > | Will you be able to prepare a formula for me, my whole issue is stuck with
| > | this one.
| > |
| > | Many thanks
| > |
| > | "Niek Otten" wrote:
| > |
| > | > Look here:
| > | >
| > | > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > |I am using VLOOKUP for training participants, the problem which I am facing
| > | > | now on my list I have got few participants with same surname and my VLOOKUP
| > | > | picks the 1st participant from the list. Any chance that I can have two or
| > | > | three cells with Vlookup formula and the cells automatically pick the 2nd and
| > | > | 3rd with same surname
| > | > |
| > | > | two sheets with name platform and participant check
| > | > |
| > | > | In platform (colomns)
| > | > | Name, Surname, date of training, venue, etc....
| > | > |
| > | > | and in the participant check
| > | > | when I type the Surname of participants it picks from the platform all the
| > | > | details for the purticular participant.
| > | > | the formula which I used is =VLOOKUP(B3,Platform!B:X,8,FALSE)
| > | > | where as B3 I type the Surname PlatformB:X is the range of Data and 8 is the
| > | > | 'first name' colomn on the platformsheet.
| > | > |
| > | > | In the participant check sheet I wanted:
| > | > | I was planing, like it to give me an option where once I type the surname it
| > | > | shows me all first name if any. or on another cell showing that there is
| > | > | another person with the same surname
| > | > |
| > | > | Please help me if there is any solution for that
| > | > |
| > | > |
| > | > | Thanks
| > | > | AP
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >
 
N

Niek Otten

I informed Ashish Mathur (the author), so he can ask MSFT to correct this.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| The example formulae cut off before completion, that is the problem
|
| "Niek Otten" wrote:
|
| > It is very important to array-enter the formulas (where indicated); press CTRL+SHIFT+ENTER, not just ENTER.
| >
| > Follow the steps in the example carefully; it should work.
| > There is nothing I can add..........
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Hi Niek,
| > |
| > | Thanks for you help, I think I am very close but its giving me an error. I
| > | am sure you will be able to help.
| > |
| > | Surname is in Platform!H
| > | Name is in Platform!I
| > |
| > | Will you be able to prepare a formula for me, my whole issue is stuck with
| > | this one.
| > |
| > | Many thanks
| > |
| > | "Niek Otten" wrote:
| > |
| > | > Look here:
| > | >
| > | > http://office.microsoft.com/en-us/excel/HA012260381033.aspx
| > | >
| > | > --
| > | > Kind regards,
| > | >
| > | > Niek Otten
| > | > Microsoft MVP - Excel
| > | >
| > | > |I am using VLOOKUP for training participants, the problem which I am facing
| > | > | now on my list I have got few participants with same surname and my VLOOKUP
| > | > | picks the 1st participant from the list. Any chance that I can have two or
| > | > | three cells with Vlookup formula and the cells automatically pick the 2nd and
| > | > | 3rd with same surname
| > | > |
| > | > | two sheets with name platform and participant check
| > | > |
| > | > | In platform (colomns)
| > | > | Name, Surname, date of training, venue, etc....
| > | > |
| > | > | and in the participant check
| > | > | when I type the Surname of participants it picks from the platform all the
| > | > | details for the purticular participant.
| > | > | the formula which I used is =VLOOKUP(B3,Platform!B:X,8,FALSE)
| > | > | where as B3 I type the Surname PlatformB:X is the range of Data and 8 is the
| > | > | 'first name' colomn on the platformsheet.
| > | > |
| > | > | In the participant check sheet I wanted:
| > | > | I was planing, like it to give me an option where once I type the surname it
| > | > | shows me all first name if any. or on another cell showing that there is
| > | > | another person with the same surname
| > | > |
| > | > | Please help me if there is any solution for that
| > | > |
| > | > |
| > | > | Thanks
| > | > | AP
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP please help 2
VLOOKUP 2
trouble with (complicated) vlookup searching another workbook 2
Dragging a formula down isn't working - where am I going wrong? 1
Vlookup and return sheet name also 2
Using a vlookup to search multiple criteria for one result? 7
VLOOKUP with more than one possible response 2
VLOOKUP and MID Function 9

Top