Easier to show than explain, assume first column has colors & second has
letters:


Red A
Blue B
Red C
Yellow D
Red E
Blue F

What set of functions can I put in a cell so that it will look for,
let's say, the third row that Red occurs in, then return the value E
from the adjacent column.

Thank you in advance
Bill


--
bill9340
------------------------------------------------------------------------
bill9340's Profile: http://www.excelforum.com/member.php...o&userid=28516
View this thread: http://www.excelforum.com/showthread...hreadid=481724