excel+courses - Match function

The UK's most regular instructor-led training courses.
Training information: excel+courses · Microsoft excel training · VBA training UK

Resolved · Low Priority · Version Standard

Match function

Sasha has attended:
Excel Advanced course
Excel Advanced course

by - delegate Sasha [1 post] (2008 Jan 30 Wed, 13:59) Reply

How does the match function work

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: match function

by - trainer Stephen gold contributer [342 posts] (2008 Feb 10 Sun, 10:07) Edited on 2008 Feb 10 Sun, 10:08 Reply

Hello Sasha

Thank you for your question

The match function simply searches through an array of data and returns the relative postion of an item that matches a particular criteria.

It has the following syntax

MATCH(lookup_value,lookup_array,match_type)

The lookup value is the criteria you are searching on

Lookup Array is the range of the array you are searching

Match type is either 1,0 or -1

1 finds the smallest value that is less than or equal to the criteria. The array must be sorted in ascending order

0 finds the first value that is exactly equal to the criteria

-1 finds the largest value that is greater than or equal to the criteria. Here the array must be sorted in descending order

Hope you're well

Regards

Stephen

· Tap the Power of Recorded Macros with MS Excel Courses
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training: Essential for Today's Employees
· Do You Really Need Excel VBA Training?
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips