+ Reply to Thread
Results 1 to 4 of 4

Excel Formula Help

  1. #1
    Registered User
    Join Date
    04-16-2017
    Location
    Windsor, England
    MS-Off Ver
    MS Office 2010
    Posts
    7

    Excel Formula Help

    Hi Guys,

    I am trying to develop a formula which can help me do the following:

    1. Looks up for two specific values in two separate columns
    2. Looks for the first value in a third column and also looks for the second value in a fourth value
    3. If both the first value and second value are found in the same row in the third and fourth columns, then the formula should return TRUE, if not, then it should return FALSE

    I've tried to illustrate the example below.

    COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4

    10002334 50 10002334 55
    10003445 60 10002334 75
    10002456 70 10002566 40
    10004567 55 10002344 50 (SHOULD MATCH)
    10004513 66 10004513 78
    10008907 41 10004513 66 (SHOULD MATCH)

    Thanks for your help in advance.

    I look forward to all of your responses.

  2. #2
    Registered User
    Join Date
    04-16-2017
    Location
    Windsor, England
    MS-Off Ver
    MS Office 2010
    Posts
    7

    Re: Excel Formula Help

    Quote Originally Posted by harvw View Post
    Hi Guys,

    I am trying to develop a formula which can help me do the following:

    1. Looks up for two specific values in two separate columns
    2. Looks for the first value in a third column and also looks for the second value in a fourth value
    3. If both the first value and second value are found in the same row in the third and fourth columns, then the formula should return TRUE, if not, then it should return FALSE

    I've tried to illustrate the example below.

    COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4

    10002334 50 10002334 55
    10003445 60 10002334 75
    10002456 70 10002566 40
    10004567 55 10002344 50 (SHOULD MATCH)
    10004513 66 10004513 78
    10008907 41 10004513 66 (SHOULD MATCH)

    Thanks for your help in advance.

    I look forward to all of your responses.
    Sorry I should have made it clear that the first task of the formula is to look for the first and second values in the same row in COLUMN 1 and COLUMN 2.
    It is then looking for these same values in the same row in COLUMNS 3 and 4.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Excel Formula Help

    Maybe this
    Enter in E1 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C D E
    1 10002334 50 10002334 55
    2 10003445 60 10002334 75
    3 10002456 70 10002566 40
    4 10004567 55 10002344 50 Match
    5 10004513 66 10004513 78
    6 10008907 41 10004513 66 Match
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Registered User
    Join Date
    04-16-2017
    Location
    Windsor, England
    MS-Off Ver
    MS Office 2010
    Posts
    7

    Re: Excel Formula Help

    Quote Originally Posted by AlKey View Post
    Maybe this
    Enter in E1 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C D E
    1 10002334 50 10002334 55
    2 10003445 60 10002334 75
    3 10002456 70 10002566 40
    4 10004567 55 10002344 50 Match
    5 10004513 66 10004513 78
    6 10008907 41 10004513 66 Match
    Thanks. The formula works like a treat!

    Out of interest, if I wanted to do this for multiple columns, i.e. look for eight different values in the same row (C1, C2, C3, C4, C5, C6, C7 C8) and then find exactly the same values in eight different columns (C9, C10, C11, C12, C13, C14, C15, C16) what would the structure of this formula look like?

+ 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. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  2. Replies: 0
    Last Post: 02-16-2016, 11:24 AM
  3. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  4. Replies: 2
    Last Post: 03-21-2014, 11:43 AM
  5. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  6. Replies: 0
    Last Post: 03-19-2012, 07:32 PM
  7. Replies: 1
    Last Post: 03-04-2012, 12:03 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