Thought I would add the formula I am currently using (thanks RagDyer and
Biff).
=INDEX($A$1:$A$426,SMALL(IF(($D$1:$BX$1=$CB$2)*($D $1:$BX$426=$CB$1),ROW(A$1:$A$425)),1))
CB2 = date to find from row 1
CB1 = letter to find from corresponding column
In each cell there might be more than one letter (ame), but I still
need to find the letter *a* if it is in that cell and return the name
from column 1. How can I make this formula find all a's even if there
is more than one letter in the cell?
Thanks for any replies.
--
CJ-22
------------------------------------------------------------------------
CJ-22's Profile:
http://www.excelforum.com/member.php...o&userid=17551
View this thread:
http://www.excelforum.com/showthread...hreadid=506632