I am looking to find a way to return a condition in a cell that would be dependent of another cell.
Where if Cell A1 value is either "EMPTY" it returns a condition in Cell A2 with "NA" or other wise with a drop down list from a data table.
The Dropdown is a list of variables only to be used if the A1 cell value is not "EMPTY"