Lookupvalue but column doesnt exist

Hi, I am trying to set up a table where not all the columns are present in the source table.   example   Col 1, Col 2, Col3,Col4   Source data only has Col1 and 3   So I want populate Col and...