Please see attached example. I am trying to have a cell programmed to show yes or no depending on a number range. Also, I need 2 lookup formulas for 2 cells to auto populate a high and low number based on the data in two other cells.