+ Reply to Thread
Results 1 to 4 of 4

Formula to return data two cells over

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    ohio
    MS-Off Ver
    Excel 2003
    Posts
    8

    Formula to return data two cells over

    Hello Experts,

    How can I use an IF/THEN formula to return data that is 2 cells to the right of the match?

    Example:

    If any cell between columns E:DA equals the word "color", return data from cell two cells to the right

    The hard part is, I'm not able to be specific about which cell I'm matching to because the attributes that I'll be matching aren't sorted. They're spread out across many columns. The formula I'm in need of will have to span columns E:DA.

    I've attached an example, it's a small sample size of 8 products out of the 10k SKUs that I'm working on.

    Thank you very much in advance,
    Matt
    Attached Files Attached Files

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

    Re: Formula to return data two cells over

    try this formula to show what is two cells to the right of color...
    =OFFSET(INDIRECT(ADDRESS(SUMPRODUCT((E2:DA2="color")*ROW(E2:DA2)),SUMPRODUCT((E2:DA2="color")*COLUMN(E2:DA2)))),0,2)
    dragged down as needed.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    01-13-2010
    Location
    ohio
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Formula to return data two cells over

    You did it! You genius!! Thank you very much! Have a great day

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

    Re: Formula to return data two cells over

    Glad that did it for you! AND thank you for the rep! You have a good day too!

+ 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] Formula to return N for cells with 0 and empty cells, and Y for cells with data
    By stpeter in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-13-2016, 05:20 PM
  2. [SOLVED] Return non-blank cells from range AND ignore cells with only formula w/o results
    By grafitti in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2014, 08:15 AM
  3. [SOLVED] Looking for a formula to reference a range of cells and return data if meets criteria
    By jeremyhawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-24-2014, 07:19 PM
  4. [SOLVED] Formula to find a Match and return row data to cells.
    By hammer2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2013, 10:56 PM
  5. criteria formula will not return data with blank cells
    By LRFT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2013, 05:01 PM
  6. [SOLVED] Formula to look at multiple cells with the same data, but only return a value once
    By jonas245 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2013, 01:36 AM
  7. [SOLVED] Formula to Return data in specific cells
    By headley4ever in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2013, 01:09 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