Hi James,
You probably want to add the third parameter to the function..
Type may take the values 1, 0, or -1. If Type = 1 or if this optional
parameter is missing, it is assumed that the first column of the search
array is sorted in ascending order. If Type = -1 it is assumed that the
column in sorted in descending order. This corresponds to the same
function in Microsoft Excel.
If Type = 0, only exact matches are found. If the search criterion is
found more than once, the function returns the first one found. Only if
Type = 0 can you search for regular expressions.
If Type = 1 or the third parameter is missing, the last value that is
smaller or equal to the search criterion is returned. This applies even
when the search array is not sorted. For Type = -1, the first value that
is larger or equal is returned.
If you data in column A is not the same type as the data in f2, no match
will be found.
tc
James Lockie wrote:
I want to match the value in cell f2, I think it is matching the string
'f2'.
=MATCH(F2;A4:A17)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
