nicelikeice , you are welcome!

Thank you so much for providing these quality excel tutorials.

appraisal951, are you taking about the Slaying Excel Dragon's DVD, or one the the 1700 videos at this site? If you have the Slaying Excel Dragon DVD, at the beginning of each video it says exactly what worksheet the video works on. If you are reading the Slaying Excel book, as you read each section tells you what worksheet you should be working on. If this doesn't answer your question, be more specific in your question and I will try to help.

caekdaemon ,
Try this alternative site (not the same as excelisfun) that is set up specifically to ask Excel questions and have dialog:

mrexcel.com/forum

(mrexcel.com is not affiliate's with excelisfun at YouTube)

This site has many people who can help you get the solutions you want.

Can you tell me what page the first lesson is on.
The work book has the index, set up, key B. None match the first video. Thanks

Hello,

I'm having some trouble with excel, and you seem like the best person for me to ask for assistance on this. I need to create a sort of merged drop down menu and tree view, that is merged directly into the spreadsheet without the use of a userform to do it. I need to be able to simply click a little tree view like button next to say the first column, and then have that display a list of the things that come under the category. So if I had 20 BMW's from 1999, the first line would display information about all the cars inside the tree view, like average price, and overall quantity. Then I could click the button, and it would display all the cars individually bellow, showing information like fittings and the such.

Sadly, I can't remember what that is called, and I can't find it on the internet because of it :(

Thanks in advance if you know :D

tobietn81, there are many ways to do it. VLOOKUP and DGET are two ways. Here is a video:

YTLE#67: VLOOKUP & DGET functions
http://www.youtube.com/watch?v­=tmDecLpWqbA

Hi ExcellsFun,

I like your excel tutorials, very educational and fun to view. I've seen it before where there is a Form and when you type in the information you're looking for such as Social Security # and all the information about the person pulls up. I'm not sure if I use Vlookup or create a form or is it something else I need to do. Any direction would help. Thank you.

Tobs

agermoune , The book only covers Excel.

LewiePsMummy , you are welcome! Good luck on the test!