Changes

|}

|}

  =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''' -

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("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 ==

== See Also ==