Eng-Tips is the largest engineering community on the Internet
Intelligent Work Forums for Engineering Professionals
-
Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: natajime80
- Order by date
-
LOOKUP in table
Thank you all for your posts. BigInch, your method works very nicely. Thanks.- natajime80
- Post #12
- Forum: -Engineering spreadsheets
-
LOOKUP in table
Thank you all for your responses. I have thought about the ceiling function but the nominal values do not have constant increments. I made my example too simple. It would look more like: Calc value = 2.5 Nominal value Size 1.8 A 3.2 B 4.5...- natajime80
- Post #8
- Forum: -Engineering spreadsheets
-
LOOKUP in table
Hello: I have a program that will give me a calculated value , and a table that lists nominal values vs. size. I need the ability to take my calculated value and find the appropiate size. However the LOOKUP function will give me the next smallest value, and what I need is the next higher...- natajime80
- Thread
- Replies: 12
- Forum: -Engineering spreadsheets
