Microsoft Excel 2007 Vlookup 1

Using Excel 2007 we create a timesaving solution for an HR department incorporating data validation and the VLOOKUP function. Watch more FREE videos at http://www.netresulttraining.com. Please rate and comment if you like this video!

Category:

Education

Tags:

• microsoft excel 2007
• vlookup
• data validation
• drop down list
• data analysis
• analyse data in Excel
• how to use vlookup
• excel vlookup function
• vlookup function
• how to use data validation
• data validating
• validate ecxel data

[thuynguyenable]

This is very interesting & helpful;however, it's a bit irritating to change the Cell and column No. when coppying the formula accross the columns. Perhaps, you need to show us more tricks.

[NetresultTraining]

Thanks - glad you found it useful. You can make life a bit easier by making the cell reference the VLOOKUP function refers to absolute. To do this, click between the column and row references in the formula bar and press F4, then Enter. Now you'll be able to copy the function across, but you'll still have to change the column reference for each field. I'll post a short video demonstrating this on YouTube.

[IPINTNA]

thanks, it helped me with my ICT work.:D

[NetresultTraining]

You're very welcome! This function is one I know a lot of people have difficulty with, so glad you liked it.

[ellis4140]

The data validation is really cool Ialways wondered how they did that

[SirWolfgaar]

Well done. This is a great example to show people. I appreciate the use of Named Ranges incorporated into the steps.