User would select contractor from a drop down (A2). Then they would enter how many units are going to be installed (A5).
Then a formula (A8) would give the approximate # of days to install based on how many units are entered.
I figure this can be done by setting up some sort of Range or AverageIf and Vlookup. Maybe something like look up how many days on average it takes the contractor to install between 1 and 10 units, 11 and 20 units, and anything over 20 units.
This is beyond my level of Excel knowledge, so any guidance is appreciated.