That didnt work... i tried to play around with it but it wont take the
right cell...

I need the formula to search through column A for a last name, then
take the corresponding cell next to it (column B) into a seperate
cell...

if i cant do this with a fomula; could it be done with two formulas or
a macro???


--
azazel
------------------------------------------------------------------------
azazel's Profile: http://www.excelforum.com/member.php...o&userid=28250
View this thread: http://www.excelforum.com/showthread...hreadid=478076