Hi all

I have a vlookup table based on hierarchy such as

1. Landuse
   - Typology/s

example
1. Residential
   - Apartments
   - Townhouses

for which i use a set of assumptions in calculating various info on
another worksheet.

For my vlookup table to work i need to sort my table on Typology.
However while reading these assumptions it would be easier if the
typologies were grouped with the Landuse without being split up.
Is there an elegant solution to having both my vlookup table work with
a list sorted on Landuse?
I can email the table if any one needs to take a look. (Currently i am
using filters but need to keep remembering to re-sort after every
print of the assumptions worksheet)
Many thanks