i need a formula that can search through a column and if a cell has the
text im looking for, pull the adjacent cell...

or i need a contains symbol for the "If" function

ex. if cell A1 contains text dude, then take value of B1 into cell C1


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