+ Reply to Thread
Results 1 to 9 of 9

IF Column A contains text in Column B then return corresponding number in C in Column D?

  1. 08-28-2012, 04:56 AM #1
    liawsiqin@gmail
    liawsiqin@gmail is offline
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    IF Column A contains text in Column B then return corresponding number in C in Column D?

    Hi all, i have a major problem....went to goggle it and just got confused along the way...


    Basically i have 4 columns....Column A is the match involved, Column B is the name of a team and column C contains numbers...I need column D to return the corresponding value in column C if column A contains text in column B, that is, 1.95 in D1...anyone can help please??? Many thanks! Attached the example sheet below...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-28-2012, 05:09 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    Hi

    Do you mean?

    =IF(ISTEXT(B1),C1,"")

    OR

    =IF(and(ISTEXT(B1),istext(a1)),C1,"")
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 08-28-2012, 05:52 AM #3
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    Do you mean this in D5

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-28-2012, 06:39 AM #4
    liawsiqin@gmail
    liawsiqin@gmail is offline
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    No, to further explain, since cell A1 (column A) contains text from cell b5 (column B), i need cell D1 to reflect the value in column c coressponding to cell b5, that is, c5 or 1.95...any ideas?? thanks for help~~!
    Reply With QuoteRegister To Reply
  5. 08-28-2012, 07:25 AM #5
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    How about this then

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 08-28-2012, 07:30 AM #6
    liawsiqin@gmail
    liawsiqin@gmail is offline
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    OMGGG!! this is very impressive!! i would never have gotten this without asking for help!! thanks so much!!
    Reply With QuoteRegister To Reply
  7. 08-28-2012, 09:08 AM #7
    liawsiqin@gmail
    liawsiqin@gmail is offline
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    Hi Bob, sorry to trouble u again,

    I tried to understand the formula and to apply it in my other sheets but i realize i don't understand it at all! =p

    Would it be possible for u to repeat your magic on another sheet so i can better understand it and apply it to the the other sheets?

    Similarly, in this case i need to see if cells in Column A contains the word/words in column D and return the corresponding cell in column F in column G. For example cell A1 contains "HJK Helsinki" (cell D6), so cell G1 should contain cell F6, that is, 1.85.

    So sorry for the trouble and thanks for the help!! im sure i can infer after this!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 08-28-2012, 11:17 AM #8
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    That extra detail makes it more convoluted, but now that I know you have Excel 2007/2010 we can simplify the formula, the two offsetting each other

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 08-29-2012, 02:36 AM #9
    liawsiqin@gmail
    liawsiqin@gmail is offline
    Registered User
    Join Date
    10-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: IF Column A contains text in Column B then return corresponding number in C in Column

    yes! i finally get it now!! thanks so much for your help!! =)))
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1