Excel Forum
Similar Content
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
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




YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functions


See how to retrieve values from more than one table. See how to populate a template with values using Data Validation, VLOOKUP, INDIRECT, COLUMN, and Custom Number format.

See how to name ranges of cells, Data Validation Drop Down List, VLOOKUP & INDIRECT & COLUMN functions and Custom Number format to retrieve values from more than one lookup table.





Got a Question? Ask it Here in the Forum.