+ Reply to Thread
Results 1 to 4 of 4

Overriding the value of the cell based on a range of other values

  1. #1
    Registered User
    Join Date
    04-12-2018
    Location
    London
    MS-Off Ver
    Excel 10
    Posts
    13

    Overriding the value of the cell based on a range of other values

    Hi,

    I need a formula to match 'employee name' (column A) to a given range (L2:M8) and if there's a match, to override 'the hours' to zero in column I.
    For all other employees I want the total hours to remain the same.

    I've attached a sample data.

    Can you please help me with the formula on Column I?

    Many thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,522

    Re: Overriding the value of the cell based on a range of other values

    How about
    =IF(ISNA(MATCH(A2,$M$2:$M$8,0)),H2,0)

  3. #3
    Registered User
    Join Date
    04-12-2018
    Location
    London
    MS-Off Ver
    Excel 10
    Posts
    13

    Re: Overriding the value of the cell based on a range of other values

    Exactly what I needed. Thank you so much!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,522

    Re: Overriding the value of the cell based on a range of other values

    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. Rank with duplicates values not overriding the next value
    By Ajoo in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-18-2019, 03:04 AM
  2. Return values to specific columns based on range of cell values
    By sbrt10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2019, 03:15 AM
  3. Sum cells in a range based between two equal cell values in another range
    By sshone1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2013, 08:12 AM
  4. Need help making a macro to copy range of values based on cell values.
    By zolton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2013, 08:58 AM
  5. Range Based on Cell Values
    By Clark in forum Excel General
    Replies: 2
    Last Post: 05-06-2009, 02:56 AM
  6. Highlight cell when overriding formula???
    By arfanvilla in forum Excel General
    Replies: 6
    Last Post: 07-29-2008, 09:55 AM
  7. [SOLVED] formula for named cell/range based on cell values
    By alex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2005, 10:05 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