Multiple VLOOKUP Answers

[chrisbeaudet]

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.

[sandy666]

Example is on Sheet2 (based on Sheet1 as source)
Result can be filtered (e.g. by Yes/No)

Please Login or Register  to view this content.

btw. on source sheet in Last Name you can use, eg. Baer Alex, Jr. etc... and in search field (yellow) you can type Alex (alex. lex, aer.....)

[wyowhite]

Look at this link. should get you going.
http://eimagine.com/how-to-return-mu...ch-or-vlookup/

[JohnTopley]

See attached:

Created a named range ("First_Name") based on the Last Name entered in B2

in R2

=IFERROR(INDEX($C$7:$C$200,SMALL(IF($B$7:$B$200=$B$2,ROW($B$7:$B$200)-ROW($B$7)+1,""),ROWS($B$7:$B7))),"")

Enter with Ctrl+Shift+Enter

in C2 created a Data Validation

Allow: =List

Source: =First_Name

In D2:

=VLOOKUP($C2,$C$7:$G$200,COLUMNS($C:C)+1,0)

Copy across

OR safer f ithere are duplicate first names

in D2

=INDEX($D$7:$G$100,MATCH(1,($B$7:$B$100=$B$2)*($C$7:$C$100=$C$2),0),COLUMNS($D:D))

Enter with Ctrl+Shift+Enter

[sandy666]

thanks for rep