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
State City
NJ Trenton
NJ Trenton
PA Philadelphia
MA Boston
Comma separated list of fields in the lookup list
InternalNameforState, InternalNameForCity
Comma separated list of fields in the current list
InternalNameforEmployeeState,InternalNameforEmployeeCity