+ Reply to Thread
Results 1 to 10 of 10

Formula, fill in descriptions based on cell content

Hybrid View

  1. #1
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Exclamation Formula, fill in descriptions based on cell content

    I'm trying to create a database layout proposal, and am having a hard time remembering how to forumlate something for the following:

    3 Sheets
    - the first is the quote (basic structure: section #, item, qty, item cost, cost)
    - the second is details about the items (section #, item, description)
    - the third is for our eyes only, and contains the data for the drop-down menu on the first page with the items along with the description

    On the 3rd sheet I have put a description of each item. So it would say "Hockey" and in the next cell "Ice Hockey is a sport played on ice"

    The problem I'm having is finding a way to auto complete the description on sheet 2 based on the item selected from the drop down menu on the first sheet.

    Hope this makes sense, any clarification needed, let me know. ANY help is much appreciated.


  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula, fill in descriptions based on cell content

    Have a look at VLOOKUP formula perhaps?

  3. #3
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula, fill in descriptions based on cell content

    I've tried but for some reason it's not jiving, can't seem to get it to bring up the right information. Been too long, maybe my brain decided to forget lol

  4. #4
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula, fill in descriptions based on cell content

    I've attached what I've started with, obviously not using Hockey but it's just an example
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula, fill in descriptions based on cell content

    Post a workbook?

  6. #6
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula, fill in descriptions based on cell content

    What is the formula you would use with VLOOKUP? Seems to be the closest option as I have tried nearly everything else

  7. #7
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula, fill in descriptions based on cell content

    I can't explain it better than the Excel Help, and can't give specific help without specific details. Posting a sample workbook would be easiest.

  8. #8
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Formula, fill in descriptions based on cell content

    Try this in C2 and copied down:

    =VLOOKUP(B2,Table2,2,FALSE)

  9. #9
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula, fill in descriptions based on cell content

    You are a CHAMP. Thank you so much

  10. #10
    Registered User
    Join Date
    10-19-2010
    Location
    Red Deer, AB
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Formula, fill in descriptions based on cell content

    What about keeping bold text bold in this situation? The descriptions are copying but bolded and underlined text is showing up plain

+ 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