I am a little confused with the VLOOKUP results I am getting....

  • Thread starter Thread starter Phillips
  • Start date Start date
P

Phillips

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
 
IIRC, sorting only matters when you are NOT returning an exact match.
Because you've specified FALSE as your 4th argument, VLOOKUP is
returning an exact match, so sorting is irrelevant.
 
Ahhhhh!!!!!

And I have always sorted before. Gee, I wish I knew Excel better!!!!

Thanks!
Phil
 
Back
Top