VLOOKUP going to next larger number


This week I have working on a rather interesting DriveWorks project where I had to select the proper size of schedule 40 pipe that a given shaft coupler could just fit inside. As an example, if I had a coupler that has an 1.4″ outside diameter, I would choose the 1-1/2″ size pipe. (From the first table below.) The problem is that if I use VLOOKUP to search the table, VLOOKUP returns the next size smaller from the table. Thus […]

Read More