+ Reply to Thread
Results 1 to 4 of 4

Forumula to return multiple values

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Forumula to return multiple values

    Hi All,

    I have a table which contains names and counts with different columns. I need a formula to return all the columns belongs with the keywords. Please find the attached samples.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,876

    Re: Forumula to return multiple values

    You will need to be more descriptive in your issue. I cannot see the logic of what you are asking. The first line appears to be the same in both files. Give us clue with some details as to where the data is that is being analyzed. How it is being analyzed. What is different between the two files.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Forumula to return multiple values

    From File1 I need to match in File2 columns and results all the three column values one after the other.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,876

    Re: Forumula to return multiple values

    Understand. See attached. Need to use Vlookup
    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. Replies: 3
    Last Post: 12-13-2013, 06:23 AM
  2. [SOLVED] Return value if within range, return multiple values if ranges overlap
    By cde1983 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2013, 06:16 AM
  3. Replies: 5
    Last Post: 08-04-2013, 09:49 AM
  4. [SOLVED] IF forumula to return text if a cell in a range contains a value <2
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2012, 08:05 AM
  5. vlookup versus sumif forumula return
    By Coors in forum Excel General
    Replies: 4
    Last Post: 02-08-2012, 02:53 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