Display +1 Results with Vlookup

[StorminASU]

Hello All,
I have consulted this website multiple times (thanks for the great help already), but have never posted because I have always been able to find what I was looking for before now.

I have a list of last names in Column B, with corresponding account numbers in Column C. I would like to be able to type a last name in A1 and have the account numbers associated with that last name appear in a drop box (data validation box, etc. it doesn't matter) in A2. Is there a way to do this?

***___A___********* ___B___******___C___
*(Typed Name)******(Last Names)****(Acct #s)
****Barron**********Adler**********150
(Box with 60 & 112)****Smith**********92
*******************Barron*********112
*******************Barron**********60
*******************Jones***********4

I apologize for the many "*"'s, but I did not know another way to keep the example from running together. Thank you in advance for all the great help!

 

[Jerry Sullivan]

Welcome to the Board!

The Contextures Site has great instructions on how to create Dependent Dropdown Lists.
http://www.contextures.com/xlDataVal13.html

Are you an ASU Sparky? I won't hold it against you!

 

[StorminASU]

Welcome to the Board!

The Contextures Site has great instructions on how to create Dependent Dropdown Lists.
http://www.contextures.com/xlDataVal13.html

Are you an ASU Sparky? I won't hold it against you!

Thanks so much for the quick response!
I'm not a Sparky, I went to Appalachian State so I'm a Mountaineer. Unless you're a Michigan fan, you've probably never heard of it, haha.

This looks like the data validation part I was looking for, but I still can't find what I'm looking for on how to return multiple responses on vlookup. I'll try attaching the file to see if that helps clarify what I'm looking for.

I would like for the user to select a name in tab Postage Sheet in cell b2, and cell b3 below populate all account numbers associated with the last name. Is this possible?

Alright, did not figure out how to attach the file. Sorry to be so much trouble

 

[Jerry Sullivan]

This looks like the data validation part I was looking for, but I still can't find what I'm looking for on how to return multiple responses on vlookup. I'll try attaching the file to see if that helps clarify what I'm looking for.

I would like for the user to select a name in tab Postage Sheet in cell b2, and cell b3 below populate all account numbers associated with the last name.

If you want a dropdown in Cell B3 that lists all Account Numbers associated with the Last Name in Cell B2, then I think you can adapt the approach in the Contextures example to your scenario.

In the Contextures example, there is a dropdown for Regions. Based on the Region selected, the user can select from a second dropdown that shows only the Customers associated with that Region. (This uses Index-Match instead of Vlookup)

In your example, the Last Name-Account Number relationship is analogous the Contextures Region-Customer relationship.

Let me know if I misunderstood or if you need more help implementing this.

 

[StorminASU]

In your example, the Last Name-Account Number relationship is analogous the Contextures Region-Customer relationship.

Let me know if I misunderstood or if you need more help implementing this.

Jerry, you nailed it! I was actually coming on the board to say I used just that relationship and it worked beautifully. Thanks so much for the great help!

I'm not sure I understand how the equation works, but at least I got it to work. Thanks again!

P.S. I hope Oregon actually wins it all it all this year and not just ends up with a huge disappointment.

 

[Jerry Sullivan]

P.S. I hope Oregon actually wins it all it all this year and not just ends up with a huge disappointment.

Glad to hear you were able to get this to work and good luck to the Mountaineers.