azazel Wrote:
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???

Bob's formula is spot on and works perfectly for me. What results are
you getting in C1 when A1 contains "Dude"? What do you expect the
results to be?

More information, please.


--
swatsp0p


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