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

Look he

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"AP" wrote in message ...
|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
|

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 he

http://office.microsoft.com/en-us/ex...260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"AP" wrote in message ...
|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
|

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

"AP" wrote in message ...
| 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 he
|
| http://office.microsoft.com/en-us/ex...260381033.aspx
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "AP" wrote in message ...
| |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
| |
|
|
|

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

"AP" wrote in message ...
| 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 he
|
| http://office.microsoft.com/en-us/ex...260381033.aspx
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "AP" wrote in message ...
| |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
| |
|
|
|

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


"Dennis" wrote in message ...
| 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
|
| "AP" wrote in message ...
| | 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 he
| |
| | http://office.microsoft.com/en-us/ex...260381033.aspx
| |
| | --
| | Kind regards,
| |
| | Niek Otten
| | Microsoft MVP - Excel
| |
| | "AP" wrote in message ...
| | |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
| | |
| |
| |
| |
|
|
|

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Dennis" wrote in message ...
| 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
|
| "AP" wrote in message ...
| | 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 he
| |
| | http://office.microsoft.com/en-us/ex...260381033.aspx
| |
| | --
| | Kind regards,
| |
| | Niek Otten
| | Microsoft MVP - Excel
| |
| | "AP" wrote in message ...
| | |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
| | |
| |
| |
| |
|
|
|