I have a list of people in an excel spreadsheet (column 1).
In column 2 is the name of the person who introduced the person in column 1
to the list (the introducers name also appears in column 1).
Column 3 is a repeat of column 1 (for vlookup to work).
In other words column contains the same name more than once.
In Column 4 I want the name of the first person introduced by the
introducer, which a simple vlookup using column 2 & 3 works.
In Column 5 I want the name of the second person introduced by the
introducer, i.e. I want vlookup to bring back the value in column 3 for the
second row in which the value in column 1 appears in column 2.
In Column 6 I want the name of the third person etc
How do I do this?