Title:
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel in conjunction with a data validation drop down menu in order to create more logical and easy to use Excel spreadsheets. This allows you to use a drop down menu to supply the lookup value to the vlookup function in Excel instead of having to type the lookup value by hand. This reduces the amount of errors when searching a database and increases efficiency in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
06/Nov/2009
Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation
Video:
Description:Visit www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to use the VLOOKUP function in Excel in conjunction with a data validation drop down menu in order to create more logical and easy to use Excel spreadsheets. This allows you to use a drop down menu to supply the lookup value to the vlookup function in Excel instead of having to type the lookup value by hand. This reduces the amount of errors when searching a database and increases efficiency in Excel. For Excel consulting or to get the spreadsheet or macro used here visit the website http There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
Published:
06/Nov/2009
No comments:
Post a Comment