advanced excel ms training - V Look Up

The UK's most regular instructor-led training courses.
Training information: advanced excel ms training · Excel/courses/london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

V Look Up

Laura has attended:
Excel Advanced course

by - delegate Laura [1 post] (2007 Sep 20 Thu, 16:44) Reply

Should I put TRUE or FALSE? Whats the difference?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: V Look Up

by - trainer Katie gold contributer [214 posts] (2007 Sep 21 Fri, 07:09) Reply

Hi Laura,

Thanks for your question.

For VLOOKUP, the function looks like this:
=VLOOKUP(Search cell, data table range, compare column, match type)

For match type:
TRUE: for near match
FALSE: for exact match

e.g. searching references: names/price, you need exact match, so you'll input FALSE

e.g. searching for a brief estimate, you will put TRUE

Hope this helps. -Katie

· Why Should I Learn Visual Basic in Excel?
· Advanced Excel Training - takes you to the next level
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees
· Tap the Power of Recorded Macros with MS Excel Courses

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips