Lookup function

**Steely** · 09-27-2011, 02:04 AM

Hello,

I cant seem to figure out how the lookup funtion works.

Table for the example is described in the attachment.

And i am trying to use =LOOKUP(100;A1:D1;A2:D2). I am expecting to get the value 940 as result but the function gives value 1200 to me as result. Cant understand why? Could someone explane why? I thought that the fuction would search the largest number at row 1 and return the value corresponding to it from row 2.

Cheers for your help!
-Steely

**zbor** · 09-27-2011, 02:20 AM

Because 100 is largest. It will look all the way to the end of row and return last number (since 100 never reached). So last number is 0 which is 1200 in second row.

**zbor** · 09-27-2011, 02:23 AM

But since there are 0's you will always get last value...

in this array:

Please Login or Register  to view this content.

this would be results:

Please Login or Register  to view this content.

**Steely** · 09-27-2011, 02:34 AM

I see. I thought that the function would always lookup the largest value of the group selected. Um what would be the best fucktion to use in the case presented to look for the largest value and get the value corresponding to it?