Excel search function

[T8keiteasy]

Hi,

I guess this is an easy one for people you "speak" curently excel...

I have a delimited column F4:F22 filled with numbers from 1 to 20.
Corresponding cells G4:G22 will be filled with names.

First cell for example C4 (once, this will be done, the function will be the same for the others cells) is filled with a name (from a validation list of names filled in G4:G22.

In D4 (the corresponding cell of C4) (in my example) I want to retrieve the value corresponding in F4.

So :
F4=1 (fixed)
G4=filled with a name :test

C4 is a list containing names: test
In D4 I want to retrieve the corresponding value of F4...

I've looked for search function, but couldn't find my way

Thank you

Now, it's about French users too !!!

 

[SkipVought]

Hi,

Use INDEX and MATCH.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[T8keiteasy]

Thank you,
I've finally done :

=RECHERCHE(C3;G3:G22;F3:F23) but I gonna check what you wrote

Thank you

Now, it's about French users too !!!