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

A

azazel

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
 
B

Bob Phillips

=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)
 
A

azazel

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???
 
S

swatsp0p

azazel said:
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???
Click to expand...

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.
 
Top