Vlookup with a range of values

[blakrapter]

Hello everyone,

I have am working on a project where I need to find U-bolt sizes that fall within a given width range. For instance, I know I need a U-bolt for one size pipe that falls between 1.25" wide and 1.75" wide, so I have a min and max cell with 1.25 and 1.75 respectfully. On another sheet, I have all of my u-bolt dimensions. I want to use the VLookup command (or something similar) to pull information from the second sheet for the U-bolt that falls within that min and max range. I would know how to do it if the bolt HAD to be 1.25", AND I had a U-bolt that was 1.25" wide, but I am dealing with ranges here. Any suggestions?

[mrice]

Have you considered using a custom autofilter to do this?

[Achidnecia]

I too have this issue in Excel 2007 only with postcodes.

Range of Postcodes
A B C
2000 2010 $1.25
2011 2020 $1.75

Please help me!

[FDibbins]

Achidnecia, please do not post questions on some-one elaes thread (thats called hi-jacking)-- start your own thread.[/B]

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.