training ms excel advanced - What is a vlookup?

Resolved · Low Priority · Version Standard

What is a vlookup?

Melanie has attended:
Excel Advanced course

by - delegate Melanie [1 post] (2007 Sep 13 Thu, 09:44) Reply

how do I use this?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: what is a vlookup?

by - trainer Carlos gold contributer [479 posts] (2007 Oct 1 Mon, 12:01) Reply

The VLookup function in Excel searches for value in the left-most column of a table_array/range and returns the value in the same row identyfied by the index_number.

The VLookup function has the following syntax:

VLookup( Value, Table_Array, Index_number, not_exact_match )

Value is the value to search for in the first column of the table_array.

Table_array is the two or more columns of data, sorted in ascending order.

Index_number is the column number in the Table_array from which the matching value must be returned. The first column of the Table_array is 1.

Not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. This means that if an exact match isn't found, then VLookup will look for the nearest value that is less than the selected value.

Regards

Carlos

· Tips for Transitioning to Excel 2007
· Microsoft Excel Training: Essential for Today's Employees
· A Beginners Guide To Formulas In Excel
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Rate this page: