vlookup for a range of data
 

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?


--
terryc
------------------------------------------------------------------------
terryc's Profile: http://www.excelforum.com/member.php...o&userid=35796
View this thread: http://www.excelforum.com/showthread...hreadid=556007

vlookup for a range of data
 

tricky without seeing the data

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


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556007