View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default VLOOKUP Range_lookup TRUE

You have to sort your table ascending.

Regards,
Per


"Pekka Numminen" skrev i meddelelsen
...
Why don't my tests work?

http://img716.imageshack.us/img716/4035/vlookuptest.gif

http://img525.imageshack.us/img525/5...ookuptest2.gif