Thread: Lookup
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Lookup

Hello,

Test Joel's and Jacob's solution with
1 2 2 333 3 444 5 555 ...
and put 2 into C10.

Do you really expect 2 as a result or would you need 222?

Regards,
Bernd