| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with a range of values
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? -- blakrapter ------------------------------------------------------------------------ blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926 View this thread: http://www.excelforum.com/showthread...hreadid=533721 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use criteria for values in range for small function | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| how to pick from a range of table values | Excel Worksheet Functions | |||
| MIN with zero values in the range | Excel Discussion (Misc queries) | |||
Linear Mode
