if one cell has "X" textin contents, then pull cell "Y"...
 

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

if one cell has "X" textin contents, then pull cell "Y"...
 

=IF(ISNUMBER(MATCH("dude",A:A,0)),INDEX(B:B,MATCH( "dude",A:A,0)),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"azazel" wrote in
message ...

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

if one cell has "X" textin contents, then pull cell "Y"...
 

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

if one cell has "X" textin contents, then pull cell "Y"...
 

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