+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Return a value based on a list

Hybrid View

  1. #1
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Return a value based on a list

    With a pivot table.

    I showed 2 examples.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  2. #2
    Registered User
    Join Date
    02-21-2011
    Location
    Salisbury, MD
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Return a value based on a list

    Not exactly. I uploaded a better picture of what I am looking to do. I have values in A2, and they are kind of all over the place, I am looking to check the contents of A to a list (So for example in column A I would have Microsoft Office 2007, Microsoft Office Powerpoint) and then in my list in say Column F I would have (SAP, Microsoft Office, Adobe). So in maybe column C, it would return Microsoft Office for those entries. I don't want to replace anything, just create a new column for a "short name"
    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)

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