Results 1 to 4 of 4

Thread: Formula Help

  1. #1

    Formula Help



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

    I have a document with two sheets and I need to find a formula that can check Column A and Column E in Sheet 1 against Column A and column B in Sheet 2. If its an EXACT MATCH I want it to return the result of the value in Column D in Sheet 2. Could somebody please help???

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by sam2015 View Post
    Could somebody please help???
    Your example file would help. Try to look at this topic

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi sam2015,
    Try below formula in cell D1(Sheet2).
    =IF(AND(EXACT(A1,Sheet1!A1),EXACT(Sheet2!B1,Sheet1!E1)),"Match","Not Match")

    Plz see the attachment.
    Attached Files Attached Files

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    I tried, but couldn't fault this compared with the one using EXACT:

    =IF(AND(Sheet1!A1= A1, Sheet1!E1=B1),D1,"")

    This assumes that you are returning the result somewhere in sheet2, and it returns blank if there is a mismatch.

Posting Permissions

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