Results 1 to 13 of 13

Look up across several columns (same row), and return value in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2009
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    58

    Look up across several columns (same row), and return value in another cell

    Hi

    I am trying to look up values in say 5 columns of each row, if the values are the same in each column, return that value to another cell.
    If the values are not the same, return a special character like "*"

    Example:
    1.Look up a name in Sheet1, A2, in Sheet2 cells A2,B2,C2,D2,E2
    2. If the values in A2,B2,C2...are the same, return that value to Sheet 1, cell B2
    3. If the vlaues are different, return "*" in Sheet 1 B2

    Basically, I'm looking up names in Sheet1, and looking for the point values in Sheet2, so that if they are all the same, I'll have that number returned to Sheet1 or a "*" to denote that the points are not the same.

    Thank you for any help on this.

    Dan
    Last edited by Dannypak; 12-13-2012 at 03:19 PM. Reason: Solved!!

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