This is just an idea. Maybe there is a better way to do it than a long formula. I have 5 globals set up for the different qty(length) of holes we put in an opening between the floors(Inside Heights). And I want to have the formula do something like this. The globals are named for how many holes there are. Formula below uses 21 hole drill pattern. Depending on let's say Inside Top Height, I may want the formula to result 5 different globals. Is that possible? Would a lookup table or something else be better??

If >=27.25 and <=45.25 then G!Linebore_Twenty_One (21 holes)

If >=24 and <=27.188 then G!Linebore_Nineteen (19 holes)

If >=21 and <=23.938 then G!Linebore_Seventeen (17 holes)

=IF(AND(Inside_Top_Height>26.938,Inside_Top_Height<45.25),G!Linebore_Twenty_One,0)

If >=27.25 and <=45.25 then G!Linebore_Twenty_One (21 holes)

If >=24 and <=27.188 then G!Linebore_Nineteen (19 holes)

If >=21 and <=23.938 then G!Linebore_Seventeen (17 holes)

=IF(AND(Inside_Top_Height>26.938,Inside_Top_Height<45.25),G!Linebore_Twenty_One,0)

# Topic Participants

## Mike Flannery

## RJ Pranski

## Jacob Edmond

## James Medelberg

## Lenny Scianna

Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.