Vlookup Help??

[jared511]

Ok so here is what I need. I need to vlookup a huge amount of data, 45,000 rows.. and here is a taste of what it looks like.


944560 = 6096096096
944560 = 6095645444
944560 = 5823452345
944560 = 3532523532
345434 = 3535152222
345434 = 4566664664


So we need to vlookup the first number, and we need multiple vlookups because on the main sheet we want to capture all the phone numbers that are encompased in the account number. So what happens obviously is that the vlookups always return the first number, whereas we need to to continue to return the other numbers. Any ideas?


Thanks,
Jared

 

[JKaz]

Hello,

I am not sure if this is what you are looking for, but this may help.

http://prakashgusain.blogspot.com/2011/02/vlookup-to-fetch-2nd-3rd-or-4th-value.html

 

[jared511]

Thanks I think this should help!

 

[T. Valko]

Ok so here is what I need. I need to vlookup a huge amount of data, 45,000 rows.. and here is a taste of what it looks like.


944560 = 6096096096
944560 = 6095645444
944560 = 5823452345
944560 = 3532523532
345434 = 3535152222
345434 = 4566664664


So we need to vlookup the first number, and we need multiple vlookups because on the main sheet we want to capture all the phone numbers that are encompased in the account number. So what happens obviously is that the vlookups always return the first number, whereas we need to to continue to return the other numbers. Any ideas?


Thanks,
Jared

With that many rows of data a typical lookup formula for multiple lookup values would be slow to calculate.

Is the data sorted or grouped together as is shown in your sample? If so, that makes things a bit easier.

Have you considered using autofilter?