I don't really understand your question, but the quick answer is that there
is no change in Vlookup from 2003 to 2007. You have always been able to use
a table that wasn't in order by using False as the fourth parameter.

Regards,
Fred

"PM in Hell" wrote in message
...
In Excel 2003, when you looked up in the Criteria table, the identifier
you
chose had to be on the end and in alpha numeric order. Is this still the
case? If I was to vlook up in multible tables and generate my own unique
information, Can I go to a table created in the vlookup and use it even if
it
is not in alpha numeric order?
Is there a work around?