Manuals/calci/LOOKUP - Revision history

Devika at 21:28, 9 August 2018

2018-08-09T21:28:39Z

Devika at 21:28, 9 August 2018

2018-08-09T21:28:22Z

Devika at 21:27, 9 August 2018

2018-08-09T21:27:21Z

Jayaram at 11:29, 14 March 2017

2017-03-14T11:29:12Z

Swapna at 18:32, 13 May 2015

2015-05-13T18:32:22Z

Swapna at 02:22, 14 February 2014

2014-02-14T02:22:52Z

Swapna: /* LOOKUP(lkup_val, lkup_vector, rslt_vector) */

2014-02-13T23:07:27Z

LOOKUP(lkup_val, lkup_vector, rslt_vector)

Swapna at 23:06, 13 February 2014

2014-02-13T23:06:32Z

Swapna at 23:03, 13 February 2014

2014-02-13T23:03:17Z

Swapna at 23:01, 13 February 2014

2014-02-13T23:01:51Z

@@ Line 5: / Line 5: @@
 *'''Array''' is the array of values or reference to one-row or one-column containing values, and
 *'''OtherArray''' is a range that contains only one-row or one-column and is same size as lkup_vector.
+**LOOKUP(),looks up values in a vector or array.
 == Description ==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''LOOKUP (Value,Array,OtherArray) '''</div><br/>
@@ Line 7: / Line 6: @@
 *'''OtherArray''' is a range that contains only one-row or one-column and is same size as lkup_vector.
-LOOKUP() looks up for a specified value in one-row range or one-column range or an array, and displays a value from same position in second one-row range or one-column range or an array.
+LOOKUP(),looks up values in a vector or array.
 == Description ==

@@ Line 1: / Line 1: @@
 =LOOKUP(lkup_val, lkup_vector, rslt_vector)=
 where,
-*'''lkup_val''' is the value to be matched from an array or range of values,
+*'''Value''' is the value to be matched from an array or range of values,
-*'''lkup_vector''' is the array of values or reference to one-row or one-column containing values, and
+*'''Array''' is the array of values or reference to one-row or one-column containing values, and
-*'''rslt_vector''' is a range that contains only one-row or one-column and is same size as lkup_vector.
+*'''OtherArray''' is a range that contains only one-row or one-column and is same size as lkup_vector.
 LOOKUP() looks up for a specified value in one-row range or one-column range or an array, and displays a value from same position in second one-row range or one-column range or an array.
@@ Line 10: / Line 11: @@
 == Description ==
-LOOKUP(lkup_val, lkup_vector, rslt_vector)
+LOOKUP (Value,Array,OtherArray)
 *LOOKUP() function can be used in two forms - '''Vector Form''' and '''Array Form'''.
 *In '''Vector Form''', Calci looks for the specified value in one-row or one-column range and returns the value from same position in second one-row or one-column range.
 *In '''Array Form''', Calci looks for the specified value in first row or column of an array, and returns the value from same position in last row or column of the array.
-*'''lkup_val''' can be a number, text or logical value, or reference to cell containing number, text or logical value.
+*'''Value''' can be a number, text or logical value, or reference to cell containing number, text or logical value.
-*'''lkup_vector''' can be one row or one column containing set of values or a reference to cells containing values.
+*'''Array''' can be one row or one column containing set of values or a reference to cells containing values.
-*Values in '''lkup_vector''' should be arranged in ascending order to obtain correct results.
+*Values in '''Array''' should be arranged in ascending order to obtain correct results.
 *Arguments containing text values entered as a part of command, should be enclosed in quotes (e.g. "JOHN").
-*Size of '''lkup_vector''' should be same as '''rslt_vector''', else Calci displays #NULL error message.
+*Size of '''Array''' should be same as '''OtherArray''', else Calci displays #NULL error message.
-*If no match is found for '''lkup_val''' in the specified range, Calci displays the largest value which is &lt;= '''lkup_val'''.
+*If no match is found for '''Value''' in the specified range, Calci displays the largest value which is &lt;= '''lkup_val'''.
 *LOOKUP function is not case-sensitive.
-*If '''lkup_val''' is less than 'smallest value in '''lkup_vector'''', Calci displays #NULL error message.
+*If '''Value''' is less than 'smallest value in '''Array'''', Calci displays #NULL error message.
 *For invalid arguments, Calci displays #NULL error message.

← Older revision		Revision as of 11:29, 14 March 2017
Line 86:		Line 86:
	*[http://en.wikipedia.org/wiki/String_(computer_science) String]		*[http://en.wikipedia.org/wiki/String_(computer_science) String]
	*[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]		*[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 62: / Line 62: @@
 |}
-  =LOOKUP(12,A2:A6,B2:B6) : Looks up for '12' in range A2 to A6 and returns value from range B2 to B6 in same row. <br />Returns '''Pencil''' as a result.
+  =LOOKUP(12,A2:A6,B2:B6) : Looks up for '12' in range A2 to A6 and returns value <br />from range B2 to B6 in same row. Returns '''Pencil''' as a result.
-  =LOOKUP(A2,A2:A6,B2:B6) : Looks up for '10' in range A2 to A6 and returns value from range B2 to B6 in same row. <br />Returns '''Pen''' as a result.
+  =LOOKUP(A2,A2:A6,B2:B6) : Looks up for '10' in range A2 to A6 and returns value <br />from range B2 to B6 in same row. Returns '''Pen''' as a result.
-  =LOOKUP(17,A2:A6,B2:B6) : As there is no exact match for '17', matches the nearest value '15' and <br />returns value from range B2 to B6 in same row. Returns '''Eraser''' as a result.
+  =LOOKUP(17,A2:A6,B2:B6) : As there is no exact match for '17', <br />matches the nearest value '15' and returns value from range B2 to B6 in same row. <br />Returns '''Eraser''' as a result.
 Following examples show the use of LOOKUP function in '''Array Form''' -
   =LOOKUP("B",["A","B","C"],[100,200,300]) : Looks up for 'B' in an array and <br />returns value in last row of array in same column. Returns '''200''' as a result.
-  =LOOKUP("cat",["A","B","C"],[100,200,300]) : As there is no exact match, Calci finds <br />the largest value &lt;= 'cat' ('C') in array and returns value in last row of array in same column. Returns '''300''' as a result.
+  =LOOKUP("cat",["A","B","C"],[100,200,300]) : As there is no exact match, <br />Calci finds the largest value &lt;= 'cat' ('C') in array and <br />returns value in last row of array in same column. Returns '''300''' as a result.
 == See Also ==

← Older revision		Revision as of 02:22, 14 February 2014
Line 11:		Line 11:

	LOOKUP(lkup_val, lkup_vector, rslt_vector)		LOOKUP(lkup_val, lkup_vector, rslt_vector)
−
−	~~e.g.~~
−	~~LOOKUP() returns~~
−
−	~~LOOKUP() returns~~

	*LOOKUP() function can be used in two forms - '''Vector Form''' and '''Array Form'''.		*LOOKUP() function can be used in two forms - '''Vector Form''' and '''Array Form'''.

@@ Line 83: / Line 83: @@
 == References ==
 *[http://en.wikipedia.org/wiki/String_(computer_science) String]
 *[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]

@@ Line 2: / Line 2: @@
 *where, '''lkup_val''' is the value to be matched from an array or range of values,
-*'''lkup_vector''' is the array of values or reference to one row or one column containing values, and
+*'''lkup_vector''' is the array of values or reference to one-row or one-column containing values, and
 *'''rslt_vector''' is a range that contains only one-row or one-column and is same size as lkup_vector.
@@ Line 16: / Line 16: @@
 LOOKUP() returns
-*LOOKUP() function can be used for two forms - '''Vector Form''' and '''Array Form'''.
+*LOOKUP() function can be used in two forms - '''Vector Form''' and '''Array Form'''.
 *In '''Vector Form''', Calci looks for the specified value in one-row or one-column range and returns the value from same position in second one-row or one-column range.
 *In '''Array Form''', Calci looks for the specified value in first row or column of an array, and returns the value from same position in last row or column of the array.
@@ Line 26: / Line 26: @@
 *If no match is found for '''lkup_val''' in the specified range, Calci displays the largest value which is &lt;= '''lkup_val'''.
 *LOOKUP function is not case-sensitive.
-*If '''lkup_val''' is &lt; 'smallest value in '''lkup_vector'''', Calci displays #NULL error message.
+*If '''lkup_val''' is less than 'smallest value in '''lkup_vector'''', Calci displays #NULL error message.
 *For invalid arguments, Calci displays #NULL error message.
@@ Line 66: / Line 66: @@
 |}
-  =LOOKUP(15,A2:A6,B2:B6) : Looks up for '15' in range A2 to A6 and returns value from range B2 to B6 in the same row. <br />Returns '''Pencil''' as a result.
+  =LOOKUP(12,A2:A6,B2:B6) : Looks up for '12' in range A2 to A6 and returns value from range B2 to B6 in the same row. <br />Returns '''Pencil''' as a result.
-  =LOOKUP(A2,A2:A6,B2:B6) : Looks up for '15' in range A2 to A6 and returns value from range B2 to B6 in the same row. <br />Returns '''Pen''' as a result.
+  =LOOKUP(A2,A2:A6,B2:B6) : Looks up for '10' in range A2 to A6 and returns value from range B2 to B6 in the same row. <br />Returns '''Pen''' as a result.
-  =LOOKUP(17,A2:A6,B2:B6) : As there is no exact match for '17', matches the nearest value '15' and returns value from range B2 to B6 in same row. <br />Returns '''Eraser''' as a result.
+  =LOOKUP(17,A2:A6,B2:B6) : As there is no exact match for '17', matches the nearest value '15' and <br />returns value from range B2 to B6 in same row. Returns '''Eraser''' as a result.
 Following examples show the use of LOOKUP function in '''Array Form''' -
   =LOOKUP("B",["A","B","C"],[100,200,300]) : Looks up for 'B' in an array and returns value in last row of array in same column. <br />Returns '''200''' as a result.
-  =LOOKUP("cat",["A","B","C"],[100,200,300]) : As there is no exact match, Calci finds the largest value &lt;= 'cat' ('C') in array and returns value in last row of array in same column. <br />Returns '''300''' as a result.
+  =LOOKUP("cat",["A","B","C"],[100,200,300]) : As there is no exact match, Calci finds the largest value &lt;= 'cat' ('C') in array and <br />returns value in last row of array in same column. Returns '''300''' as a result.
 == See Also ==
@@ Line 83: / Line 83: @@
 == References ==
-*[*[http://en.wikipedia.org/wiki/String_(computer_science) String]
+*[http://en.wikipedia.org/wiki/String_(computer_science) String]
 *[http://en.wikipedia.org/wiki/Comparison_of_programming_languages_(string_functions)#Find Find String]