The purpose of this function was to grab the item of which the sale had sold. There was a whole sheet dedicated to producing the values for this still complex formula to work with.
=IF(IF('Enter DatA Here'!J2<=Welcome!$C$4,IFERROR(IF(E2="Closing Insum",'Enter DatA Here'!D2,IF(E2="Closing Revenue",'Enter DatA Here'!D2,IF(E2="Closing Expense",'Enter DatA Here'!D2,IF(E2="sale",RIGHT('Enter DatA Here'!D2,LEN('Enter DatA Here'!D2)-11),IF(E2="filled",'Enter DatA Here'!D2,""))))),""))=FALSE,"",IF('Enter DatA Here'!J2<=Welcome!$C$4,IFERROR(IF(E2="Closing Insum",'Enter DatA Here'!D2,IF(E2="Closing Revenue",'Enter DatA Here'!D2,IF(E2="Closing Expense",'Enter DatA Here'!D2,IF(E2="sale",RIGHT('Enter DatA Here'!D2,LEN('Enter DatA Here'!D2)-11),IF(E2="filled",'Enter DatA Here'!D2,""))))),"")))
