vlookup for a range of data

[terryc]

I'm having some real problems trying to figure out how to do something
in Excel....

Basically, I have a large, indigestible table of data. What I want the
user to do is to select a range of electricity generator sizes from a
pull-down menu - e.g. "0-1 KW", "1-5 KW" etc.

There will then be another worksheet in which a similar table is
presented. However, this table will only display the data range
selection. E.g. if they've selected "1-5 KW", then the table will only
display 1-5 KW generators.

The problem is that using VLookup, I can get Excel to take specific
values, e.g. I can make it look up 1, 2, 3, etc., but I don't know how
to make it look for a range of 1-5. Does anyone know how to do this?

 

[baxybaxy]

tricky without seeing the data

i think you'll need to do something like adding an additiona
true/false column to both your detail data and your selection field
and use the sumif or sumproduct formul