Excel Data Validation List & VLOOKUP

25 Responses to “Excel Data Validation List & VLOOKUP”

1. ExcelIsFun on: 21 March 2010 at 4:02 pm

   Yes, to see how to use the excelisfun channel, search for excelisfun and then go to the channel and then watch the video that plays automatically — it will show you how to search and download.
2. coolboxbueno on: 21 March 2010 at 4:31 pm

   No way! You offer a range of really great magic tricks! =D no way!
3. PennyGregory1 on: 21 March 2010 at 5:22 pm

   Thanks for the help -very generous!
4. ExcelIsFun on: 21 March 2010 at 5:45 pm

   I don’t know how to do that. Try the Mr Excel Message Board:

   mrexcel[dot]com/forum
5. PennyGregory1 on: 21 March 2010 at 6:35 pm

   THanks, YOu Tubers Love Excell #1 gave me the answer to my first question – COOOL! But how about if you’ve used VLOOKUP in an invoice, the the price goes up? I can see you can just create a totally new record, but is there a way of linking price to date or something, so that old invoices show old price and new invoices show new/current price? I have lots of columns on my product worksheet, only price will vary with time, so could do with a really easy solution. Yr help much appreciated.
6. ExcelIsFun on: 21 March 2010 at 7:13 pm

   Try these:

   Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice

   You Tubers Love Excel #1: Dynamic Data Validation & OFFSET
7. PennyGregory1 on: 21 March 2010 at 7:24 pm

   Love the vids – Pls can you tell me though, in this example, if we add more products at a later date, would they appear in the dropdown list? Also, how do you deal with a product price increase? eg. Product 175 may be 14.99 through 2009, but on 1/1/10, it rises to 15.99. If the VLOOKUP was being used in invoices, for example, how could you make sure your 2009 invoice records don’t change as soon as you put the price up? Bet you have vids for this too?!? Lol! So amazing what Excel can do! Thx.
8. ExcelIsFun on: 21 March 2010 at 8:21 pm

   Yes.
9. lmo930 on: 21 March 2010 at 8:27 pm

   Ahh…yes this is on a Mac with Office 2008. So you’re saying on a PC when the validation list is extremely lengthy you can page down several times, click your mouse on an item in the list and it fills in the cell?
10. ExcelIsFun on: 21 March 2010 at 8:49 pm

    I cannot duplicate the problem in Excel 2007 or Excel 2010 on a PC. If you have a Mac, I am of no use to you becasue I do not how to use a Mac.
11. lmo930 on: 21 March 2010 at 8:51 pm

    this is great when the validation list in short, but i have a list of over 300 and once I page down in the validation list, excel 2008 no longer allows me to select an item with my cursor. If I click on any item not on the first screen in my validation list, the validation window closes and no selection is made. I have to use the arrows to highlight the item I want and press enter. Why?
12. forzadimilano on: 21 March 2010 at 9:23 pm

    NOWAY!
13. ExcelIsFun on: 21 March 2010 at 9:45 pm

    EXCELlent!!!
14. tekesbur on: 21 March 2010 at 10:36 pm

    love it!:)
15. ExcelIsFun on: 21 March 2010 at 10:42 pm

    You are welcome!
16. tahwnikcufos on: 21 March 2010 at 11:10 pm

    Great Vid!!! Your enthusiasm is a bonus! Thanks!
17. ExcelIsFun on: 21 March 2010 at 11:34 pm

    You are welcome!

    Be sure to search for ‘excelisfun’ and go to the channel to search for any Excel topic that you want!
18. Violetster on: 22 March 2010 at 12:10 am

    your passion for this stuff is contagious. Keep up the good work and thanks for sharing your skilzzzz…..’no way!’ LMAO! Love it! Cheers!
19. ExcelIsFun on: 22 March 2010 at 12:39 am

    Try this video title:

    Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
20. ExcelIsFun on: 22 March 2010 at 12:40 am

    Don’t fing watch them if they are annoying.
21. kristjanvaik on: 22 March 2010 at 1:15 am

    Your tutorials are awesome, but, maaan, at times your super-fing annoying Thanks a thousand, really useful stuff!
22. ExcelIsFun on: 22 March 2010 at 2:00 am

    This was the #5 video that I made. I have made over 900 newer videos since then that are much better quality.

    Search for and watch this video title which shows how to get to my channel and search for videos:

    Search For Excel Videos Download Excel Files excelisfun

    I have about 80 other videos just about VLOOKUP.
23. gdareos on: 22 March 2010 at 2:02 am

    This is the first YouTube Excel tutorial, and I think it’s really good. I”ve been working with Excel a while, but had always used the FORM combo box. This is easier Thanks!! Perhaps you could improve the video resolution??
24. ExcelIsFun on: 22 March 2010 at 2:31 am

    Ctrl + F3 gets to the list of names and you can delete there.
25. frank850102 on: 22 March 2010 at 3:17 am

    Hi Mike, I would like to know how to delete the name of the table once we have given a name?
    When I press the F3 key, there is no “delete”. So could you please tell me how to delete the names within the “F3″.

    Cheers