lookup two different variables

P

pbuscio

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top