+ Reply to Thread
Results 1 to 4 of 4

cOMBINE Index match and IF formula (from the value returned)

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    cOMBINE Index match and IF formula (from the value returned)

    Hi all,

    Here's my formula in a cell:

    =INDEX(Sheet1!U:U,MATCH(Test!A2,Sheet1!$E:$E,FALSE))

    How can I add a formula within the cell to include, IF="Fully Lined", "Yes", "No"

    Basically if the value from the index match returns Fully Lined, change it to Yes, or No (if it does not return fully lined)

    Thank you
    Thanks,

    R.



  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: cOMBINE Index match and IF formula (from the value returned)

    =IF(INDEX(Sheet1!U:U,MATCH(Test!A2,Sheet1!$E:$E,FALSE))="Fully Lined",Yes","No")

    ...should do that.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: cOMBINE Index match and IF formula (from the value returned)

    Great thanks Glenn!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: cOMBINE Index match and IF formula (from the value returned)

    You're welcome & thanks for the feedback.

+ 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. Need something like INDEX MATCH with MIN value returned
    By kwoltman in forum Excel General
    Replies: 2
    Last Post: 03-02-2021, 11:44 PM
  2. [SOLVED] Sum duplicate values returned by array formula INDEX(MATCH(LARGE(IF)))
    By TFiske in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-02-2017, 07:18 PM
  3. [SOLVED] Shared Value not being returned using Index/Match and Mode Formula
    By ShakJames in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-10-2017, 07:14 PM
  4. formula to combine columns sum/index/match
    By mecexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-12-2015, 05:40 PM
  5. Need 0 Value Returned for NA# on Index Match Formula
    By dharrier in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2015, 08:21 PM
  6. Replies: 4
    Last Post: 01-10-2014, 05:09 PM
  7. Replies: 10
    Last Post: 08-19-2013, 11:33 AM

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