| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with vlookup and return based on a formula
Hello!
I am working with sheet metal. For any given metal, I have various sizes available. I want to use vlookup my metal and then return the appropriate size based on the length of the part I need to take out of it. Example, my table looks like: METAL SIZE1 SIZE2 Stainless 36x90 48x120 PlainSteel 40x90 60x120 And the part I am building is using Stainless with a length of 80". So using the table, I want to lookup "stainless", and my formula answer would be "36x90" because that would fit my 80" part. I know how to set up vlookup, but I don't know how to incorporate a formula to assess my part length versus my sheet lengths available. Anyone know? Thanks for the help--laura |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a working formula from a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP and return formula | Excel Worksheet Functions | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Threaded Mode
