+ Reply to Thread
Results 1 to 6 of 6

Pasting objects if results contain character

  1. #1
    Registered User
    Join Date
    08-25-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Pasting objects if results contain character

    Hello Excel people,

    I'm trying to do the following:

    If the results of a formula in a specific cell contain a certain character, like an "A" in the word "DAVID", then I want to paste an object in another cell.

    Can this be done?

  2. #2
    Registered User
    Join Date
    08-25-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Pasting objects if results contain character

    Bumped in hope of response

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Pasting objects if results contain character

    Here is an article that shows how to use Vlookup to return a picture.

    Is that the kind of thing you are looking for?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    08-25-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Pasting objects if results contain character

    Actually NBVC this is related to the sheet you helped me with.

    http://www.excelforum.com/excel-gene...ered-data.html

    I'm trying to get something to appear on a label if there are mixed sizes, and thought looking for the "/" that seperated the sizes would be a good start. But I think the item I want on the labels with mixes isnt an object anyway now, and it could be shown or hidden with conditional formatting maybe.

    You'll see the item I'm trying to use in the attached.

    Could you have a look please?

    *edit* and I'm trying to get it to appear from H11:L17.
    Attached Files Attached Files
    Last edited by NBVC; 08-26-2011 at 10:12 AM. Reason: added link to other sheet for those who want to follow

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Pasting objects if results contain character

    Yes, Conditional Formatting would probably be a good way to manage that.

    See attached.

    First Note, I missed one tiny detail in my formulas A15 and A18 of the box sheets. Currently if you have 2 quantities next to each other for any box, then there would be no / separating the sizes in these cells.... so...

    Please replace A15 with:

    Please Login or Register  to view this content.
    and A18 with:

    Please Login or Register  to view this content.
    Now with the formatting.....

    First remove the colour background and bold from your current "object" in Data sheet. Then select it and click the Format Painter from the left side of the Home tab.

    Go to sheet 1 and click say G5, you should get a big empty white box., then

    In G5, I added formula: =IF(ISNUMBER(SEARCH("/",A15)),"Mixed Size Carton","")

    Then I applied conditional formatting on that cell, through Home tab, Conditional Formatting, New Rule.

    Select Format Only Cells That Contain from the top Rule types section.

    Select Cell Value >> Is Equal To >> and enter: ="Mixed Size Carton"

    Click Format and choose Bold from Font tab and Red colour from Fill tab.

    Click Ok, click Ok to end.

    I did sheets "1" and "2" for you....


    Edit: I just saw your edit... use H11 instead of G5 in my sample.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-25-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Pasting objects if results contain character

    Ok, thanks NBVC, I'll look into that later.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1