Sort by List

M

Manosh

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
 
R

Roger Govier

Hi

There is no need to sort your list to work with Vlookup, provided you
use the 4th parameter and set it to FALSE or 0.

=VLOOKUP(your_item,your_table,your_offset,0)
 
M

Manosh

Hi

There is no need to sort your list to work with Vlookup, provided you
use the 4th parameter and set it to FALSE or 0.

=VLOOKUP(your_item,your_table,your_offset,0)

--
Regards

Roger Govier











- Show quoted text -
Click to expand...

Thanks Roger - Didnt realise it was that straight forward!
 
Top