Yes. That works perfectly for Column V. However, for Column E I am essentially needing it to take Column U and divide it by Column E, but I can’t figure out how to do this with an “IF” statement so that I don’t get #DIV error messages where there is not input data. See attached. Thank you for helping too.

Attached Files

Copy of Floodcoat Workup_Combos_LGC_12-15-15_2.xlsx (39.3 KB, 9 views)

Like this:

Attached Files

Floodcoat Workup_Combos_LGC_12-15-15_3.xlsx (39.4 KB, 10 views)

This is good, but I can't get cell V51/52 to pull-up the correct price when it references the cell above it. According to my chart on the upper right 200,000 - 500,000 should be $91, but no matter what I do I keep getting $87. Thank you.

Attached Files

Floodcoat Workup_Combos.xlsx (39.3 KB, 10 views)

Maybe like this:

Attached Files

Floodcoat Workup_Combos_2.xlsx (39.4 KB, 10 views)