lookup two different variables
 

Hello, I have a table as follwos say


a b c d e f g
1 14 15 3 5 6 9 11
2 22 11 23 2 0 5 14
3 11 9 6 7 8 4 1


I am trying to pull those values to a similar table

a d e g b c f
1
2
3


vlookup works but only if i manually enter the columns. The issue is that the table i am drawing from is linked to a database and i am not sure that the columns will be the same every time. Any ideas?