VLookup in Excel 2007 - question on setup

[PM in Hell]

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?

 

[Fred Smith]

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

 

[Gord Dibben]

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