Hi .
I am trying to fill in a cell based on the contents of another cell. Specifically, I want to fill the cell with a Drop Down List that I have defined in another worksheet and labeled accordingly.
My formula looks like this .........
IF(ISBLANK(C8),"",=TrxTypeList)I am trying to insert the formula into "Sheet 1", while I have the Drop Down List defined (and labeled) in "Sheet 2".
My Excel file is attached
Can somebody please help me?
Thank you