Manuals/calci/MATCH
Jump to navigation
Jump to search
MATCH(lkup_val,lkup_arr,m_type)
where lkup_val is the value which is use to find the value ,lkup_arr is a contiguous range of cells containing possible lookup values and
m_type is the number -1, 0, or 1.
It gives the relative position of an item in an [javascript:AppendPopup(this,'xldefArray_1') array ]that matches a specified value in a specified order.
MATCH
Let's see an example in Column1Row1:Column1Row4
Green 45
Red 39
Blue 47
Yellow 26
I.e.=MATCH(40,C1R1:C1R4,1) is 4
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Green | 45 | ||
| Row2 | Red | 39 | ||
| Row3 | Blue | 47 | ||
| Row4 | Yellow | 26 | ||
| Row5 | 4 | |||
| Row6 |
