+ Reply to Thread
Results 1 to 3 of 3

recherche correspondance exacte d'une cellule

  1. #1
    Registered User
    Join Date
    03-26-2021
    Location
    paris
    MS-Off Ver
    2016
    Posts
    1

    recherche correspondance exacte d'une cellule

    bonjour à tous,
    dans le tableau ci joint je voulais saisir le niveau et le temps correspondant a chaque employé dans les cellules bien déterminé.
    mes commentaires sont sur le tableau.
    besoin d'aide en urgence svp.
    Attached Files Attached Files

  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 2406
    Posts
    44,409

    Re: recherche correspondance exacte d'une cellule

    Dans A10, copié à travers et vers le bas:

    =IFERROR(INDEX('SUIVI PROD'!$A:$K,AGGREGATE(15,6,ROW('SUIVI PROD'!$C$2:$C$15)/('SUIVI PROD'!$C$2:$C$15=Suivi!$B$4),ROWS(A$11:A11)),MATCH(A$10,'SUIVI PROD'!$A$1:$J$1,0)),"")


    Cependant, je ne sais pas quelle colonne doit être retournée pour TJ.H.

    En France, vous devrez utiliser; et pas ,
    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

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

    Re: recherche correspondance exacte d'une cellule

    Votre fichier est maintenant joint.
    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 recherche et imprimer etat
    By nizar2016 in forum Non English Excel
    Replies: 1
    Last Post: 12-23-2015, 07:00 PM
  2. Replies: 0
    Last Post: 11-16-2013, 03:40 AM
  3. [SOLVED] Correspondance between Columns in two Sheets
    By rajiv1988 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2013, 06:15 AM
  4. Send a mail trough Lotus Notes /CRM/ Correspondance
    By rekoj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 10:21 AM
  5. Replies: 0
    Last Post: 02-09-2012, 10:06 AM
  6. Replies: 6
    Last Post: 04-04-2008, 03:30 AM
  7. [SOLVED] =FONCTION(CELLULE(A1)) ?
    By Olivier SOW in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2005, 05:05 AM

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