I'm trying to pull multiple values from a singe column. (I think I'm
saying that right)

This is basically what I'm trying to figure out.

A B C D E
Name Phone Position Sun Mon
6/3 6/4
CCU/ICU
Gretchen 754-3720 CCRN/Dir A
Lisa T 423-1642 CCRN A
Virginia 423-1076 CCRN
Teena 423-1343 CCRN A A
Jonean 465-4005 RN/3 P
Dave 423-2426 RN/3 A
Allyson 423-2269 RN/3 P P
Sarah 427-3853 CCRN

I need to search through column D for all "A" values and have it
return columns A&C to a different worksheet. I have tried using Alan
Beban's (Vlookups) to return one column [the name column]and it works
except it returns all references to the "A" value across all the
columns. For instance if the lookup value was "P" it would return two
instances of Allyson where I only need it to search down and return
Allyson only if the lookup value in that one column is "P". If anyone
can help I would greatly appreciate it.