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