Results 1 to 5 of 5

Multiple VLOOKUP Answers

Threaded View

  1. #1
    Registered User
    Join Date
    02-08-2017
    Location
    Greenwood, SC
    MS-Off Ver
    2010
    Posts
    18

    Multiple VLOOKUP Answers

    I am working on a spreadsheet for a wedding guest list. My sister wants it to where if she types in a last name, it'll bring up all the information for them. I have used VLOOKUP and done this successfully. The only thing I am struggling with is when we have multiple guests with the same last name. Is there anyway I can use VLOOKUP to either a) bring back all of the people who have the same last name or b) make it so there's a drop-down box when I type the last name so I can choose between all of the results. I have attached the spreadsheet and highlighted in yellow what I am talking about. Thank you for any help.
    Attached Files Attached Files
    If my answer helped, say thanks. Add reputation.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vlookup with Multiple Answers in Lookup Cell!
    By lkbarnes in forum Excel General
    Replies: 7
    Last Post: 02-23-2016, 04:57 PM
  2. keep getting repeat answers using vlookup
    By garvey1973 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2015, 04:25 PM
  3. Vlookup Multiple answers and place in label captions
    By jamie030489 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2015, 11:09 AM
  4. [SOLVED] Want to use VLOOKUP with two answers
    By jim0000 in forum Excel General
    Replies: 6
    Last Post: 07-02-2015, 12:27 AM
  5. [SOLVED] VLOOKUP returning multiple answers from table
    By Cyclewench in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-06-2013, 03:18 AM
  6. Return Multiple answers with vlookup?
    By JohnXDoe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2008, 08:34 AM
  7. [SOLVED] Can VLOOKUP return multiple answers based on several identical lo.
    By jddtct in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2005, 03:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1