+ Reply to Thread
Results 1 to 3 of 3

Having trouble creating a formula using VLOOKUP, possibly, to compile information

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    Cincinnati, OH
    MS-Off Ver
    Excel 2010
    Posts
    7

    Having trouble creating a formula using VLOOKUP, possibly, to compile information

    Basically what I need is a formula and a formula within a formula, if that’s possible, that will create the descriptions from the sentences that I created. See the attached spreadsheet. Do I need to set it up differently and how do I set up the formula to do this? Title_Description_Details 10-16.xlsx

    For example,

    The title of the product is Diamond Bridal Rings 14K White Gold Princess Solitaire with Side Stones Set (1.01 ct.tw.)

    I have written sentences for Diamond, Bridal set, 14k White Gold, Princess, Solitaire. I need to take each of those sentences, plus the title and put them together to write a description. I also would like to have it fill in the gold weight and color and the diamond carat weight and color and clarity where appropriate.

    So the description for this one would read:

    Diamond Bridal Rings 14K White Gold Princess Solitaire with Side Stones Set (1.01 ct.tw.) Beautiful coordinating engagement ring and wedding band set in 14k white gold is the perfect symbol of love for your special day and forever. A simple, classic, light gold color, 14k white gold is a rare gold valued for its lustrous shine. The brilliant diamonds are a beautiful (XX) color and (XXX) clarity.

    The Princess cut is a modern, square or rectangle cut increasing in popularity and known for its brilliance. The Solitaire is the most popular diamond ring setting because of its simplicity and its classic design featuring a single center stone. This ring features a (0.xxx) carat center stone with a total carat weight of 1.01 ct.tw.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Having trouble creating a formula using VLOOKUP, possibly, to compile information

    I have changed the thread title on your 1st thread, you can continue on that 1, I will close this(duplicate) thread

    Thanks
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Having trouble creating a formula using VLOOKUP, possibly, to compile information

    self-deleted duplicate post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trouble Creating a Formula to auto populate multiple sheets
    By jjb1email in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2013, 01:23 AM
  2. Replies: 0
    Last Post: 05-28-2012, 05:01 PM
  3. Replies: 2
    Last Post: 04-05-2010, 05:13 PM
  4. Trouble Creating a Formula
    By RoutnAbout in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-19-2008, 09:23 PM
  5. Replies: 0
    Last Post: 01-21-2008, 12:44 PM

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