Manuals/calci/DGET
DGET(db,fld,cri)
where db is the range of cells that makes up the list or database,
fld shows which column is used in the function and
cri is the range of cells that contains the conditions that we specify.
It obtain a single value from a column of a list or database that matches conditions that we specify.
DGET
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 ]
[javascript:ToggleDiv('divExpCollAsst_4') R1 Name Age Salary ]
[javascript:ToggleDiv('divExpCollAsst_4') R2 <30 ]
[javascript:ToggleDiv('divExpCollAsst_4') R3 >40 >5000]
[javascript:ToggleDiv('divExpCollAsst_4') R4 Name Age Salary]
[javascript:ToggleDiv('divExpCollAsst_4') R5 John 34 5500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R6 Bill 35 6500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R7 Clark 29 7000 ]
[javascript:ToggleDiv('divExpCollAsst_4') R8 Bob 45 9000]
[javascript:ToggleDiv('divExpCollAsst_4') R9 Susan 37 4000]
[javascript:ToggleDiv('divExpCollAsst_4') R10 Jill 45 8000 ]
[javascript:ToggleDiv('divExpCollAsst_4') I.e =DGET(C1R4:C3R10,”Salary”,C1R1:C2R2) is 7000]
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Name | Age | Salary | 7000 |
| Row2 | <30 | |||
| Row3 | >40 | >5000 | ||
| Row4 | Name | Age | Salary | |
| Row5 | John | 34 | 5500 | |
| Row6 | Bill | 35 | 6500 | |
| Row7 | Clark | 29 | 7000 | |
| Row8 | Bob | 45 | 9000 | |
| Row9 | Susan | 37 | 4000 | |
| Row10 | Jill | 45 | 8000 |
