Thread: 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.

Have a look at VLOOKUP formula perhaps?

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

Post a workbook?

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

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.

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

Try this in C2 and copied down:

=VLOOKUP(B2,Table2,2,FALSE)

You are a CHAMP. Thank you so much

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