+ Reply to Thread
Results 1 to 1 of 1

formula help, anything more efficient than 3 IFs?

  1. #1
    Forum Contributor TechRetard's Avatar
    Join Date
    06-14-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    202

    formula help, anything more efficient than 3 IFs?

    I have a quick example that I was wondering if there is a more efficient formula for

    expectedoutcolumn - "match" for each unique name in column A, if any of those unique records have a match in column2 to the inputed number

    [inputed number:](can change) [10]
    A B ....... C ....... expectedoutputColumn

    AA 10 ..... match.... match
    AA 11 ....... 0....... match
    AA 12 ....... 0 ....... match
    BB 09 ...... 0.......
    CC 10 .... match .... match
    CC 11 ....... 0 ....... match
    CC 13 ....... 0 ....... match
    DD 15 ....... 0 .......

    rules: colum C 'match' will always be the first record; column A will be sorted

    current formula that works: IF(C2="match","match",IF(D1="match",IF(A2=A1,"match",""),""))

    edit:
    Please Login or Register  to view this content.
    Last edited by TechRetard; 02-03-2011 at 02:26 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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