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

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

Post by Phillip » Wed, 26 Nov 2003 02:45:20


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
 
 
 

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

Post by Diann » Wed, 26 Nov 2003 02:58:49

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.

--
HTH,
Dianne


Phillips <Phillips*NOSPAM*@RecycledReefs.com> typed:

 
 
 

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

Post by Phillip » Wed, 26 Nov 2003 03:04:48

Ahhhhh!!!!!

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

Thanks!
Phil
 
 
 

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

Post by Alan Beba » Wed, 26 Nov 2003 07:08:55


But that isn't what the help says.

Alan Beban