yes i did, i tried and it didn’t work. Here is what i have done. I cannot show the real lists due to confidentiality.
My Base List Column
EMployeeName, EMployeeAddress, EmployeeState, EmployeeCity
My lookup list is similar to a State , city list. So i have list columns named State and City, with Values NJ, PA and MA and a City column with Values Trenton, Newark, Jersey City, Philadelphia, Boston etc
Comma separated list of fields in the lookup list
Comma separated list of fields in the current list