+ Reply to Thread
Results 1 to 7 of 7

Nested if comparing column values

  1. #1
    Registered User
    Join Date
    06-18-2018
    Location
    ATLANTA,GA
    MS-Off Ver
    360
    Posts
    3

    Nested if comparing column values

    cell F = CS
    cell K = anther uom, cell L = qty for that uom,
    cell M = another uom, cell N = qty for that uom etc.

    I have once unit of measure which I need to match from 7 potential units of measure
    which ever unit of measure it matches, I want it to bring back the qty in the adjacent cell

    so, if F2=K2 then L2
    if not then IF F2=M2 THEN N2
    if not then IF F2=O2 THEN P2

    etc.

    In its entirety I need to compare F to K, M,O,Q,S,U,W
    if any are equal to F then I need to bring back the cell adjacent L,N,P,R,R,V,X

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Nested if comparing column values

    this would be one way...
    =IF(F2=K2,L2,IF(F2=M2,N2,IF(F2=O2,P2,IF(F2=Q2,R2,IF(F2=S2,T2,IF(F2=U2,V2,IF(F2=W2,X2,"")))))))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    06-18-2018
    Location
    ATLANTA,GA
    MS-Off Ver
    360
    Posts
    3

    Re: Nested if comparing column values

    GENIUS! Thanks Sam C

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Nested if comparing column values

    Maybe also...

    =INDEX(L2:X2,MATCH(F2,K2:W2,0))
    Last edited by jeffreybrown; 12-05-2018 at 12:59 PM.
    HTH
    Regards, Jeff

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Nested if comparing column values

    Interesting one Jeff, I'll have to try it to see how it works.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Nested if comparing column values

    And thank you for the rep sandyga2!

  7. #7
    Registered User
    Join Date
    06-18-2018
    Location
    ATLANTA,GA
    MS-Off Ver
    360
    Posts
    3

    Re: Nested if comparing column values

    Thanks jeff, worked equally as well!!

+ 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] Comparing Same Column to Column for Matches and then Comparing Offset Values
    By Exia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-01-2015, 12:00 PM
  2. Replies: 19
    Last Post: 03-15-2014, 04:50 PM
  3. Replies: 3
    Last Post: 10-15-2012, 10:42 AM
  4. Grouping rows based on column values and comparing row values
    By bernborough in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2010, 10:18 AM
  5. Comparing column values?
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2007, 04:09 AM
  6. comparing column values
    By gall in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-26-2006, 01:55 PM
  7. Comparing column values
    By Mark Christensen in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 02:50 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