Excel Formula - formula based on if cell contains

I'm not sure how to explain this situation.  Cell   A2 has the following contents   D20    D20 will be used in multiple formulas throughout the spreadsheet.  It is one of the variables.      Cell...