Forum Discussion

dls5u's avatar
dls5u
Copper Contributor
May 30, 2025
Solved

VLookup + multiple answers

I have created a spread sheet of client names and numbers and am using VLOOKUP to bring up information.  The lookup is by last name and there are instances where there are more than one in the list. ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 05, 2025

    This

    =FILTER(Providers!A2:G150,Providers!A2:A150=B6)

    might work.

    It's very similar to what Harun24HR​ has already suggested. The only difference is that FILTER uses e.g. Providers!A2:G150 instead of e.g. A.:.B.

Chris_Apps4Rent's avatar
Chris_Apps4Rent
Brass Contributor
May 31, 2025

VLOOKUP only returns the first match. To get all matches, use this (Excel 365+):

=TEXTJOIN(", ", TRUE, FILTER(B2:B100, A2:A100=D1))

This returns all values from column B where column A matches the name in D1.

  • dls5u's avatar
    dls5u
    Copper Contributor
    Jun 05, 2025

    Thanks, that does show the different names but I have several columns that I'm trying to pull information for those names.  Phone # from column C, Fax from Column D, Practice name from Column E, etc. and display those.

     

Resources