software

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.25quot; wide and 1.75quot; 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.25quot;, AND I had a U-bolt that
was 1.25quot; wide, but I am dealing with ranges here. Any suggestions?--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: www.excelforum.com/member.php...oamp;userid=28926
View this thread: www.excelforum.com/showthread...hreadid=533723
Have you considered using a custom autofilter to do this?--
mrice------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=533723