i have a sheet containing daes in column a, a name in column b and
another name in column c


no column b name will be reeated for each date.

i want to get the name in column c by matching the name in column b and
date in column a


a b c
1/2/6 bob fizz
1/2/6 pete fizz
2/2/6 bob pepsi
2/2/6 steff orange
2/2/6 pete pepsi
3/2/6 bob lemon


from the example i want to use the name bob and the date 2/2/6 to get
orange.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=534329