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

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

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

In news:Qsrwb.293341$Tr4.926743@attbi_s03,
Phillips typed:
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....
 

Ahhhhh!!!!!

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

Thanks!
Phil

"Dianne" wrote in message
...
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

In news:Qsrwb.293341$Tr4.926743@attbi_s03,
Phillips typed:
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....
 

Phillips wrote:
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