Formula, fill in descriptions based on cell content

[sinnes]

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.

[StephenR]

Have a look at VLOOKUP formula perhaps?

[sinnes]

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

[StephenR]

Post a workbook?

[sinnes]

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

[StephenR]

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.

[sinnes]

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

[StephenR]

Try this in C2 and copied down:

=VLOOKUP(B2,Table2,2,FALSE)

[sinnes]

You are a CHAMP. Thank you so much

[sinnes]

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