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