+ Reply to Thread
Results 1 to 7 of 7

Vlookup from a range that have the same name

  1. #1
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    Vlookup from a range that have the same name

    Hi,
    I need to match information regarding customers, however, since the list sometimes have the customer's name multiple times it doesn't work with my vlookup formula. I guess it only works when there is unique entries? I need the comments in column F to find the comments in column C.

    Could somebody help me, please?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,278

    Re: Vlookup from a range that have the same name

    Maybe this option will work?
    Formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Vlookup from a range that have the same name

    Since you are using Office 365 you could use TEXTJOIN. here is an example: https://www.get-digital-help.com/exc...into-one-cell/
    Click the * to say thanks.

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Vlookup from a range that have the same name

    In F3 then copy down

    =IFERROR(INDEX($C:$C,AGGREGATE(15,6,ROW($C$3:$C$9)/($B$3:$B$9=$E3),COUNTIF($E$3:$E3,$E3))),"")
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  5. #5
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    Re: Vlookup from a range that have the same name

    Thank you Czeslaw: It worked for that selection. However, I bumped into some problems when I expanded it.

  6. #6
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    Re: Vlookup from a range that have the same name

    Thank you PaulM100 : That was a very interesting and easy way, however, whenever there was multiple entries of the same customer with no comments it showed "0" for every entry of the customer where the comment was blank. But other than that it worked great.

  7. #7
    Forum Contributor
    Join Date
    10-31-2012
    Location
    Norway
    MS-Off Ver
    Excel in Office 365
    Posts
    147

    Re: Vlookup from a range that have the same name

    Your solution worked the best, kvsrinivasamurthy. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Use Vlookup to insert a named range for the vlookup Table
    By thewholefoot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2018, 12:56 PM
  2. Using Match and Vlookup to find the lookup range for a Vlookup
    By locopete999 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2017, 09:09 AM
  3. [SOLVED] VLOOKUP and Fill Handle Problem: Selected Range vs. Named Range
    By Menenius in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-12-2016, 08:50 PM
  4. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  5. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  6. Replies: 6
    Last Post: 09-04-2012, 10:35 AM
  7. Insert Vlookup into table_array of Vlookup with named range
    By Denise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2005, 07:06 PM

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