Excel Forum
Similar Content
VLOOKUP() Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when yo...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 328: VLOOKUP Without 1st Column


See how to use VLOOKUP when you do not have a first column to use for lookup. Also see how to make the table range dynamic for the VLOOKUP function. See Excel 2003 List and Excel 2007 Table feature for dynamic ranges for VLOOKUP table and Data Validation List.





Got a Question? Ask it Here in the Forum.