Is there any reason you’re opposed to setting the names of the two sets to be the same?
rbind will work just fine in that case, and you can just use something like names(test2) <- lookup_table$first so that the names match up.
3
solved Append data frame to another data frame with different column names