Need formula to look at two cells that are the same, and extrapolate data from another cell.

[whovis]

I am trying to find a formula that will look at identical data in once column (such as an accession number), then look at data in the same rows but in a different column, and pull that data out into another column, I am trying to identify the name of the phlebotomist. The first 4 rows are the same patient. The same phlebotomist drew all 4 tubes of blood, but one is "NUR". I need to know that in this example "NUR" is "BROWN, CHARLIE"

The data i look at is extremely large. Here is an example:

TestID	Accession #	Phlebotomist
HIV12	A917009168	BROWN, CHARLIE
RPR	A917009168	BROWN, CHARLIE
REDX	A917009168	NUR
VENIP	A917009168	BROWN, CHARLIE
CTGC	A917009169	LEPEW, PEPPY
CXURN	A917009210	LEGHORN, FOGHORN
FLCD4	A917009305	FUDD, ELMER
RC	A917009748	DUCK, DAFFY
RENAL	A917010128	PIG, PORKY
OSMO	A917010129	CAT, TOM
GRNX	A917010129	NUR
MG	A917010159	DISNEY, WALT
APTT	A917010197	MOUSE, MINNIE
BLUX2	A917010197	NUR
DGNAX	A917010197	NUR
VENIP	A917010197	DUCK, DAFFY
CBCBO	A918001550	BUNNY. BUGS
CBCWD	A918001550	BUNNY. BUGS
CMP	A918001550	BUNNY. BUGS
CRP	A918001550	BUNNY. BUGS
MG	A918001550	BUNNY. BUGS
PHOS	A918001550	BUNNY. BUGS
SFLGS	A918001550	BUNNY. BUGS
TRIG	A918001550	BUNNY. BUGS
GRNX	A918001550	NUR
VENIP	A918001550	DUCK, DAFFY

I can sort by accession number to lump them all together. I need to formula to look the accession number (A917009168 in the first four rows), use the data "NUR" in row 3, and return the name in either row 1,2 or 4 (since the all are under the same accession number.

I appreciate any help.

 

[whovis]

Thanks. Have a great weekend.