Manuals/calci/VLOOKUP
where lkup_val is the value to search in the first column of the table [javascript:AppendPopup(this,'xldefArray_1') array][javascript:AppendPopup(this,'xldefArray_1') ,]
tb_arr is the two or more columns of data,
c_index_n is the column number in table_array from which the matching value must be returned and
range_lk is a logical value that specifies whether one should want VLOOKUP to find an exact match or an approximate match:
- ODDFYIELD shows the error value, when 'settle', 'M', 'I', or 'FC' is not a valid date or 'R' or 'Yield' < 0.
- Basis must be between 0 and 4.
- M >FC > settle > I
VLOOKUP
Let's see an example
[javascript:ToggleDiv('divExpCollAsst_1') C1 C2 C3]
[javascript:ToggleDiv('divExpCollAsst_1') R1 0.327 4.52 600]
[javascript:ToggleDiv('divExpCollAsst_1') R2 .423 4.21 500]
[javascript:ToggleDiv('divExpCollAsst_1') R3 0.517 3.87 400]
[javascript:ToggleDiv('divExpCollAsst_1') R4 0.574 3.15 300]
[javascript:ToggleDiv('divExpCollAsst_1') R5 0.643 2.98 200]
[javascript:ToggleDiv('divExpCollAsst_1') R6 0.711 2.75 150]
[javascript:ToggleDiv('divExpCollAsst_1') R7 0.857 2.5 100]
[javascript:ToggleDiv('divExpCollAsst_1') R8 2.04 .0.987 50]
[javascript:ToggleDiv('divExpCollAsst_1') R9 2.18 0.975 0]
[javascript:ToggleDiv('divExpCollAsst_1') =VLOOKUP(1,C1R1:C3R9,2) is 2.5]
[javascript:ToggleDiv('divExpCollAsst_1') ///rly =VLOOKUP(1,C1R1:C3R9,3,TRUE) is 100]
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 0.327 | 4.52 | 600 | 2.5 |
| Row2 | .423 | 4.21 | 500 | 100 |
| Row3 | 0.517 | 3.87 | 400 | |
| Row4 | 0.574 | 3.15 | 300 | |
| Row5 | 0.643 | 2.98 | 200 | |
| Row6 | 0.711 | 2.75 | 150 | |
| Row7 | 0.857 | 2.5 | 100 | |
| Row8 | 2.04 | 0.987 | 50 | |
| Row9 | 2.18 | 0.975 | 0 |
