Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Enter Value in column based on text entry (Excel 2003)

    I need to enter the value of a cell in a new column based on a text entry in another column. I am attaching this example worksheet so you can see what I mean. If the text entry "blue951" is in A2, then I need the entry of B2 (its cost) to be pasted into E2. If the text entry "red089 is in A3 then I need the entry of B3 (its cost) to be pasted into F3. Attachement of example included.

    Thank you for any help you can give
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Enter Value in column based on text entry (Excel 2003)

    Enter this formula in E2:
    <code>
    =IF(ISERROR(SEARCH(SUBSTITUTE(E$1,"?",""),$A2)),"" ,$B2)
    </code>
    and fill down, then right.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Enter Value in column based on text entry (Excel 2003)

    Perfect....thank you so very much
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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