Results 1 to 4 of 4

Thread: Formula for if two numbers match

  1. #1

    Formula for if two numbers match



    Register for a FREE account, and/
    or Log in to avoid these ads!

    The calculation i am after is,

    if the number in range (G1:G5) Matches the number in (A1:E1) then = A4 -(answer) otherwise A4.

    Thank you for any help
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Hi,

    Before asking new questions, please close off your open threads.

    Also, if you are crossposting (as was discovered in a previous thread, please post all links to those threads). Please read this: http://www.excelguru.ca/content.php?184

    After that, pertaining to this thread.... I am not sure I get what you are looking for. Please give us some expected results based on the data in the sheet.


  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,463
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Still cross posting without links http://www.excelforum.com/excel-form...28#post3326128

  4. #4
    Sorry didnt realise about the rules on cross posting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •