V Look ups

Resolved · Medium Priority · Version 2003

Thu 9 Dec 2010, 16:36 Delegate Emily said...

Emily has attended:
Excel Intermediate course

V Look ups

Would like more information on how to do V Look Ups

Tue 14 Dec 2010, 13:48 Trainer Anthony said...

RE: V Look ups

Hi Emily, thanks for your query. There is a walk through of Lookups in the manual for your course which should have reached you by now. If it hasn't please contact your course organiser as it may have got lost in the digital mail. A complete walkthrough of VLOOKUPs is rather a lot to type here, so try the following link which takes you to a good overview of how to create and use Lookups.

http://www.mrexcel.com/tip096.shtml

Hope this helps,

Anthony

Mon 20 Dec 2010: Automatically marked as resolved.

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature.

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips

V Look ups

V Look ups

RE: V Look ups

Excel articles

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010