+ Reply to Thread
Results 1 to 15 of 15

How to match cell value using Match function

  1. #1
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    How to match cell value using Match function

    Hi Excel experts

    I am trying below formula

    Please Login or Register  to view this content.

    and it work fine if my Sheet2 match first value but now i have range of cells , now how to Match the value i had attached the excel
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by mailtoashok13; 06-08-2021 at 05:26 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: How to match cell value using Match function

    MATCH on Column B will return the first value only i.e TESTA, TESTAA

    Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

  3. #3
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    I had attached the sample excel please look and let me know the result

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    In F2 then copy down.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  5. #5
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    Thank you for the response but i have to follow below conditions check then Search the result below is my formula with checks it work but it always work if First value matches

    Please Login or Register  to view this content.
    I also updated my Excel sory i attached the wrong one row 4 in Sheet1 is updated with expected output "AAAAAAA - GGGGG"

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    Pl see post #4

  7. #7
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    This Formula work if it Matches with First one but there is range now in Sheet 2 how to change this formula so it work with range selection ?Like in Column B of Sheet 2
    ColumnA ColumnB
    XXXX JJJJJJJJJJJ– DDD BBB AA-YYY
    LLLLL FFFFFFFF – UUU BBB AA-YYY
    XXXX YYYYYYY – DDD BBB AA-YYY
    JJJJJJ YYYYYYY – DDD BBB AA-YYY
    YYYYYYYY - GGGGG FF -DDD
    SSSSSSSSS - BBBBBB FF -DDD
    AAAAAAA - GGGGG FF -DDD
    YYYYYYYY - GGGGG FF -DDD
    YYYYYYYY - BBBBBB FF -DDD

  8. #8
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    Formula will check For match of D value with Column A and E value with column B. If both matches only result .will be given.
    In the formula you see both D2 And E2 are used.

  9. #9
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    Thanks for your quick response but i have to check few conditions before like IF(AND(A2="OK",B2=C2 then i have to perform check so could you help me in adding above conditions before

  10. #10
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    In F2

    =IF(D2="","", IF(AND(A2="OK",B2=C2),IF(SUMPRODUCT(ISNUMBER(SEARCH(Sheet2!$A$2:$A$10,Sheet1!D2))*(Sheet2!$B$2:$B$10=Sheet1!E2))>0,D2,""),""))

  11. #11
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    Hi i tried this and getting below output in ColumnF expectation to getting match value in ColumnF so if my Match found "AAAAAAA - GGGGGG" it should update Column F with "AAAAAAA - GGGGGG"


    Attachment 735686

  12. #12
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    Your attachment is not opening . Pl upload once again. Pl read yellow banner in the top of this page.

  13. #13
    Registered User
    Join Date
    06-01-2021
    Location
    sweden
    MS-Off Ver
    365
    Posts
    18

    Re: How to match cell value using Match function

    The MATCH work looks for a predefined thing in a scope of cells, and afterward returns the overall situation of that thing in the reach. For instance, assuming the reach A1:A3 contains the qualities 5, 25, and 38, the equation =MATCH(25,A1:A3,0) returns the number 2, since 25 is the second thing in the reach.

  14. #14
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: How to match cell value using Match function

    attached please check

  15. #15
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How to match cell value using Match function

    In F2

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. VBA function to match multiple criteria faster than vlookup or index match
    By bkav1991 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2020, 09:14 AM
  2. Replies: 15
    Last Post: 06-09-2020, 10:41 AM
  3. How to apply an Index.Match.Match function to all entries in a Listbox on a User Form
    By jason.drozd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2018, 01:54 AM
  4. Replies: 5
    Last Post: 03-29-2018, 01:56 PM
  5. [SOLVED] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  6. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  7. Replies: 5
    Last Post: 10-26-2012, 02:21 PM

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