writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 66:
Line 66: − + − + − + − +
no edit summary
|}
|}
=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(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(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(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(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', 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''' -
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("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 the largest value <= 'cat' ('C') in array and <br />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, Calci finds <br />the largest value <= 'cat' ('C') in array and returns value in last row of array in same column. Returns '''300''' as a result.
== See Also ==
== See Also ==