Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - V Look Up

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced excel ms training - V Look Up

Resolved · Low Priority · Version Standard

Reply Thu 20 Sep 2007, 16:44Delegate Laura said...

Laura has attended:
Excel Advanced course

V Look Up

Should I put TRUE or FALSE? Whats the difference?

For upcoming training course dates see: Pricing & availability

Reply Fri 21 Sep 2007, 07:09Trainer Katie said...

RE: V Look Up

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

Excel articles

· Sorting Out Your Data In Excel
· What's Better Than the Help Function in Excel? Microsoft Training
· A Hidden Gem In Excel - Formula Auditing
· Charting Another Dimension With Excel
· Creating Error Alerts In Excel Using Data Validation

Excel tip:

Change the Print button so it brings up the Print dialogue box

If you want to bring up the Print dialogue box to check your print settings when you hit the Print button, do the following:

1. Right-click on the toolbar that displays the Print button.

2. Select Customise.

3. Click on the Print button on the toolbar to select it, then hold the left mouse button down and drag the button towards the screen below. The button should come off the toolbar.

4. In the Customise dialogue box on your screen, select the Commands tab.

5. Select File from the Categories list, and then locate the Print... icon (looks like the normal Print button, but the word Print has three dots following it).

6. Click on the Print... icon to select it, then use your left mouse to drag and drop the icon onto the toolbar at the top of the screen.

7. Close the Customise dialogue box.

View all Excel hints and tips