View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillips Phillips is offline
external usenet poster
 
Posts: 48
Default I am a little confused with the VLOOKUP results I am getting....

I have the following

=VLOOKUP(E2,'Finished Results'!E:F,1,FALSE)

It is working fine, just I am not getting quite the results I was expecting!

According to the help, I should have the ref table sorted by the feild I am
looking for. In this case, even with out it sorted, I seem to be getting the
correct results!

Am I missing something here? Do I need to sort the data? Is there something
wrong in the help file?

Thanks
Phil