+ Reply to Thread
Results 1 to 6 of 6

Match a range of cell’s position with a cell’s value & if TRUE get another cell’s value

  1. #1
    Forum Contributor
    Join Date
    10-18-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 2010
    Posts
    427

    Post Match a range of cell’s position with a cell’s value & if TRUE get another cell’s value

    I have range of data Range1 E2:O2 (11 cells) values in which are either of 444 or <>444 with a caveat that at a time, at the most, only one 1 cell of E2:O2 may contain 444; columns are contiguous.

    B2=has formula which generated value either of 1 to 11 or zero or null

    Output cell (formula requested for this) T2 as described below

    If 444 is generated in the ‘same number of position’ of E2:O2 which is equal to B2, T2=R2 else T2=null.
    T2=null if B2=0 or null
    T2=null if there is no 444 found in any of the cells E2:O2.

    How to accomplish please?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,151

    Re: Match a range of cell’s position with a cell’s value & if TRUE get another cell’s valu

    ? maybe this ?
    IF(OR($B2="",$B2=0),"",IF($B2=MATCH(444,$E2:$O2,0),$R2,""))

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,070

    Re: Match a range of cell’s position with a cell’s value & if TRUE get another cell’s valu

    Another option
    =IF(IFERROR(MATCH(444,E2:O2,0),"")=B2,R2,"")

  4. #4
    Forum Contributor
    Join Date
    10-18-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 2010
    Posts
    427

    Re: Match a range of cell’s position with a cell’s value & if TRUE get another cell’s valu

    Quote Originally Posted by porucha vevrku View Post
    ? maybe this ?
    It works. Thanks porucha vevrku

  5. #5
    Forum Contributor
    Join Date
    10-18-2019
    Location
    Mumbai
    MS-Off Ver
    OFFICE 2010
    Posts
    427

    Re: Match a range of cell’s position with a cell’s value & if TRUE get another cell’s valu

    Quote Originally Posted by Fluff13 View Post
    Another option
    It works. Thanks Fluff13

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,070

    Re: Match a range of cell’s position with a cell’s value & if TRUE get another cell’s valu

    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. [SOLVED] Find if cell value is in range of other workbook and if true, copy-paste an offset cell
    By Szechter in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2019, 01:54 PM
  2. Replies: 6
    Last Post: 03-26-2016, 05:49 PM
  3. [SOLVED] Change range cell color if cell is TRUE
    By sherrillpitts in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-29-2015, 06:43 AM
  4. [SOLVED] match specific cell if another cell in same row is true, then paste in other worksheet
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-27-2014, 01:17 AM
  5. Replies: 2
    Last Post: 07-27-2014, 11:48 PM
  6. Replies: 1
    Last Post: 01-03-2014, 03:01 AM
  7. Does a cell match exactly to another cell from a list, true/false?
    By MushroomFace in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-30-2013, 08:49 PM

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