Changes

6,991 bytes added , 02:39, 25 October 2013

Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=..."

<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">

Syntax

</div></div>
----
<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">

Examples

</div></div>
----
<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
----
<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">

<font size="5">Description</font>

</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">LOOKUP</font> </font>'''</div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''LOOKUP'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''lkup_val'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''lkup_vec'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''res_vec'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where lkup_val is a '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">value that LOOKUP searches for in the first vector, </font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''lkup_vec is a '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">range that contains only one row or one column and </font></font></font>

<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''res_vec is a '''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">range that contains only one row or column. </font></font></font>

</div></div>
----
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">

<font color="#484848"><font face="Arial, sans-serif"><font size="2">LOOKUP gives a value either from a one-row or one-column range or from an </font></font></font>[javascript:AppendPopup(this,'xldefArray_1') <font color="#000000"><font face="Arial, sans-serif"><font size="2">array</font></font></font>]<font color="#484848"><font face="Arial, sans-serif"><font size="2">.</font></font></font>

</div></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">Let's see an example in C1R1 : C2R5</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">C1 C2</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">R1 10 Apple</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">R2 20 Orange</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">R3 30 Lemon</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">R4 40 Pear</font></font></font>]

[javascript:ToggleDiv('divExpCollAsst_1') <font color="#666666"><font face="Arial, sans-serif"><font size="2">R5 50 Guava</font></font></font>]

<font color="#666666"><font face="Arial, sans-serif"><font size="2">I.e. =LOOKUP(30,C1R1:C1R5,C2R1:C2R5) is lemon</font></font></font>

</div></div>
----
<div id="6SpaceContent" class="zcontent" align="left">

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class=" " |
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| class=" " | Column1
| class=" " | Column2
| class=" " | Column3
| class=" " | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f " | 10
| class="sshl_f " | Apple
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class=" " | Row2
| class="sshl_f" | 20
| class="sshl_f" | Orange
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| Row3
| class="sshl_f" | 30
| class="sshl_f" | Lemon
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| Row4
| class="sshl_f" | 40
| class="sshl_f" | Pear
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class=" " | Row5
| class=" " | 50
| class="sshl_f " | Guava
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class="sshl_f" | Row6
| class="sshl_f" | Lemon
| class="sshl_f " |
| class="sshl_f" |
| class="sshl_f" |
|- class="odd"
| class="sshl_f" | Row7
| class="sshl_f SelectTD SelectTD" |
<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|- class="even"
| class="sshl_f" | Row8
| class="SelectTd" |
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| class="sshl_f" |
| class="sshl_f" |
| class="sshl_f" |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----
</div></div></div></div></div></div></div></div></div>

MassBot1

Bots, writer

193,448

edits

Changes

Manuals/calci/LOOKUP (view source)

Revision as of 02:39, 25 October 2013

Navigation menu

Search