+ Reply to Thread
Results 1 to 2 of 2

Lookup table with lookup reference with comma separated values

Hybrid View

  1. #1
    Registered User
    Join Date
    05-06-2024
    Location
    Indonesia
    MS-Off Ver
    365
    Posts
    1

    Post Lookup table with lookup reference with comma separated values

    Hello, thanks for your support. I need your help.
    I'm using excel desktop
    I have table with several data with prices :

    In range $A$2:$C$7, but in Column "service tag" we have data serveral service tag in one cell.

    In range $G$3:$G$13 we want find prices with cell references from F1 until F13 from range $A$2:$C$7.

    I'm sorry my english is not fluent. Hereby i attach example files.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,040

    Re: Lookup table with lookup reference with comma separated values

    I guess what you want is this.

    =LET(
      a,FILTER(B3:C100,B3:B100<>""),
      DROP(REDUCE(0,SEQUENCE(ROWS(a)),LAMBDA(m,n,VSTACK(m,DROP(REDUCE(0,TEXTSPLIT(INDEX(a,n,1),,",",1),LAMBDA(x,y,VSTACK(x,HSTACK(y,INDEX(a,n,2))))),1)))),1)
    )
    Attached Files Attached Files

+ 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. [SOLVED] XLOOKUP when the lookup value has comma separated cell
    By Eades1412 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-06-2024, 11:43 AM
  2. [SOLVED] How to find a match with lookup values that are separated by comma
    By Eades1412 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-07-2022, 07:48 AM
  3. Lookup & return multiple values in one cell, separated by comma
    By cav0731 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2020, 10:51 AM
  4. [SOLVED] Sum values using vlookup with lookup cell containing comma separated values
    By tmalito in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-08-2019, 10:14 AM
  5. Comma separated list with vertical lookup
    By tamxc4 in forum Excel General
    Replies: 0
    Last Post: 04-13-2012, 11:05 AM
  6. Replies: 1
    Last Post: 11-10-2011, 12:57 PM
  7. Return Y/N after matching from multiple lookup values separated by comma
    By indoglans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2011, 03:13 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