I am trying to use a Vlookup, in a Spreadsheet that has 15000 records. Column A has account numbers (which are repeated a few times) and Column B has person names.
What I am trying to do is Vlookup repeat account numbers and show the person linked to that account in the form of a row.
Vlookup how ever looks at the first Value search only, Is it possible to use mulitple values.
example: - Current Setup (Column C has formula =VLOOKUP(A2,A2:B8,2,FALSE)
A B C
account
123 Joe bloggs Joe bloggs
234 P Smith P Smith
546 D Johnson D Johnson
123 Fred Bloggs Fred Bloggs
223 C Smith C Smith
123 K Bloggs K Bloggs
234 D Smith D Smith
Required Setup
A B C D E
123 Joe bloggs Joe bloggs Fred Bloggs K Bloggs
234 P Smith P Smith D Smith
546 D Johnson D Johnson
123 Fred Bloggs Fred Bloggs
223 C Smith C Smith
123 K Bloggs K Bloggs
234 D Smith D Smith
Help someone
What I am trying to do is Vlookup repeat account numbers and show the person linked to that account in the form of a row.
Vlookup how ever looks at the first Value search only, Is it possible to use mulitple values.
example: - Current Setup (Column C has formula =VLOOKUP(A2,A2:B8,2,FALSE)
A B C
account
123 Joe bloggs Joe bloggs
234 P Smith P Smith
546 D Johnson D Johnson
123 Fred Bloggs Fred Bloggs
223 C Smith C Smith
123 K Bloggs K Bloggs
234 D Smith D Smith
Required Setup
A B C D E
123 Joe bloggs Joe bloggs Fred Bloggs K Bloggs
234 P Smith P Smith D Smith
546 D Johnson D Johnson
123 Fred Bloggs Fred Bloggs
223 C Smith C Smith
123 K Bloggs K Bloggs
234 D Smith D Smith
Help someone