Is it possible to build a formula that reads the value in a cell (that
references another cell) versus reading the formula in a cell?

For example, if a greater than value: IF A4A5, but the value in A4 is a
reference from another table, is there a way to do this, so the formula reads
the value, not the formula within the cell?

Thanks!
--
Andrea