I am trying to use only 1 formula to populate the information in various columns which are not adjacent to each other.
I want to bring the information in table 1 from table 2, from all the column which are common.
ID# is my unique identifier. Also, i cannot delete any columns from any table...