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

[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

 

[Dianne]

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.

 

[Phillips]

Ahhhhh!!!!!

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

Thanks!
Phil

 

[Alan Beban]

According to the help, I should have the ref table sorted by the feild I am
looking for.

But that isn't what the help says.

Alan Beban