+ Reply to Thread
Results 1 to 11 of 11

How to find associated values in a table according to a specific research?

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    169

    How to find associated values in a table according to a specific research?

    Good morning to the community.
    I work on the file "Test".

    I have a table located in column A et B where i want to search the data.

    I have the table located in the column E and F from where i want to take the data.

    I have the table located in the column H and I where i want to display the results.


    For example, i would like to know if the value AF is located in the table (column A&B) and display the values on the table H&I with the values of "code pays cible" and "nom du pays".

    I think i need to use recherchev, but it didn't work.

    Thank you for your help.

    test.png
    Attached Files Attached Files
    Last edited by Luu4466; 09-17-2022 at 04:45 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: How to find associated values in a table according to a specific research?

    Since the picture doesn't match your file... and there are no expected results in the file, a guess.

    =IFERROR(VLOOKUP(H2,E:F,2,FALSE),"")
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    169

    Re: How to find associated values in a table according to a specific research?

    Sorry, I need to change my thinking. I changed the picture and the associated file. Now, the name of the file is "Test2".
    I would like to display the values that are different between the table located in column A&B and the column located in the column E&F.

    For example, I put for "code pays cible" AF and for "nom du pays" Africa" and I put for "code pays cible" AT and for "nom du pays" Atrium.

    My expected results should be:


    | Results Code pays cible | Results Nom du pays |
    |--------------------------|-----------------------|
    | AF | Africa |
    | AT | Atrium |


    Attachment 796618

    Thank you for you help
    Attached Files Attached Files
    Last edited by Luu4466; 09-17-2022 at 04:46 AM.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to find associated values in a table according to a specific research?

    In I2 copied down:

    =IFERROR(INDEX($F$2:$F$252,MATCH(TRIM(H2),$E$2:$E$252,0)),"")

    =HVIS.FEJL(INDEKS($F$2:$F$252;SAMMENLIGN(FJERN.OVERFL?DIGE.BLANKE(H2);$E$2:$E$252;0));"")
    Attached Files Attached Files
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: How to find associated values in a table according to a specific research?

    Seems much the same, but...

    =IFERROR(VLOOKUP(H2,E:F,2,FALSE),"")

    delete the trailing space after AF in H2.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    169

    Re: How to find associated values in a table according to a specific research?

    Yes yes yes. It is working. Here is the formula in french.
    Thnak you a lot.

    Capture d??cran 2022-09-17 105434.png
    Attached Files Attached Files

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: How to find associated values in a table according to a specific research?

    For what it is worth, it is better to CLEANSE you data - removing the extra spaces. Otherwise you will always have problems with your formulae - endlessly cleansing dirty data. "AF " is NOT the same as "AF".

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to find associated values in a table according to a specific research?

    Glad to have helped.

    If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

    Your location is Copenhagen - I would not expect you to have been using a French locale. Is your location correct?

  9. #9
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,341

    Re: How to find associated values in a table according to a specific research?

    Please try in H2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    169

    Re: How to find associated values in a table according to a specific research?

    Thank you for all your answer @Glenn Kennedy, @AliGW and @HansDouwe.
    - AliGW, I gave you toom uch contribution, I can't do more according to the forum/
    - GlennKenndy, I will think in the future to cleanse the data.
    - HansDouwe, thank you for this other strategy.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to find associated values in a table according to a specific research?

    You're welcome.

+ 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. The fastest way to find specific values within table
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-20-2019, 12:39 AM
  2. Replies: 5
    Last Post: 03-05-2017, 04:07 PM
  3. Macro in excel to copy specific values from a table with a specific criteria
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2015, 05:40 AM
  4. Macro to find all specific values in column and replace adjacent cell values
    By dblock02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 06:03 AM
  5. Replies: 1
    Last Post: 04-19-2013, 08:30 PM
  6. [SOLVED] Using range.find to find two specific values in two columns
    By mhrub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 01:02 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