VLookup in Excel 2007 - question on setup
 

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?

VLookup in Excel 2007 - question on setup
 

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?

VLookup in Excel 2007 - question on setup
 

What you state is not entirely true.

In either version of Excel..............

If range_lookup is True then table_array must be sorted.

If set to False, no need for sorting.

=VLOOKUP(value,table_array,colindex,False)

If you check out help on VLOOKUP you will see this information.


Gord Dibben MS Excel MVP

On Fri, 12 Feb 2010 16:30:21 -0800, PM in Hell
wrote:

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?