Lookup

[Guest]

We use Excel 2003 for staff scheduling. Under each date (col C, D) we enter
the facility they are working at. At the bottom we want to return the
initials (col B) of who is working at the facility JE. I tried
=LOOKUP("JE",C2:C6,B2:B6) - that doesn't work correctly. My example should
display BB, not MT. Any direction would be very appreciated.

A B C D
Name Initials 11/12 11/13
Bob B. BB JE JE
Cathy K CK DT DT
Bob S BS DT DT
Mary MT DT DT
Ann AM MO MO

who JE MT

 

[Guest]

Wonderful! That worked! Can you tell me what the Match type =0 means? I
have other applications for this function and I don't understand that part.
Thanks so much.

 

[Guest]

Try this:

=INDEX(B2:B6,MATCH("JE",C2:C6,0))

HTH,
Elkar

 

[Guest]

A Match Type of 0 looks for an exact match to the lookup value. Since you
are looking for a specific text string, this is the only option that works.
Other types 1 or -1 look for the closest match that is either greater than or
less than the lookup value. These options really only make sense for numbers.

You can find more info on this in the Excel Help file under the MATCH
Function.

HTH,
Elkar