| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Linear Mode
