+ Reply to Thread
Results 1 to 3 of 3

Returning a non-numerical value that matches another list

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Sweden
    MS-Off Ver
    Microsoft Office 365 ProPlus Version 2002
    Posts
    26

    Returning a non-numerical value that matches another list

    Hello,

    I have uploaded a simple file showing what im trying to accomplish.

    I'm trying to make a formula in the yellow cells. In these cells I want to return the Industry of a company using the table to the left.

    I've done a similar thing with numbers before. Although the function doesnt work here, because I dont want to summarize and its a non-numerical value..

    I've used "SUMIF($D$5:$J$5;"O6";$D$6:$J$6)", however, its wrong in several ways. But it might make it easier for you to understand what im trying to do.

    Maybe the function "Index" or "Match" should be used? I cant figure out how...

    /Peter
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    28,655

    Re: Returning a non-numerical value that matches another list

    One way:
    =LOOKUP(O6,$D$5:$J$5,$D$6:$J$6)

    In Sweden, you may need ; instead of ,
    Glenn



  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,620

    Re: Returning a non-numerical value that matches another list

    Another way:

    =INDEX($D$6:$J$6,MATCH(O6,$D$5:$J$5,0))

    or:

    =HLOOKUP(O6,$D$5:$J$6,2,0)

+ 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] Want to extract partial matches from a list and add to existing list of retreived matches
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2019, 02:31 PM
  2. [SOLVED] Summing the matches of one column only if its corresponding description matches a list
    By bishop-jese-erl in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-19-2015, 04:26 PM
  3. Returning a numerical value from text
    By MattCufre in forum Excel General
    Replies: 1
    Last Post: 10-25-2013, 04:56 AM
  4. [SOLVED] Returning a Day from a numerical date formatt
    By CliveH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2013, 08:23 AM
  5. Replies: 1
    Last Post: 05-27-2010, 11:56 AM
  6. Text returning a numerical value
    By slinger1010 in forum Excel General
    Replies: 3
    Last Post: 11-14-2006, 08:24 AM
  7. [SOLVED] Round/Ceiling on an IF function returning numerical value or text
    By donnaK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2005, 12:25 PM

Tags for this Thread

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