View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pbuscio@comcast.net is offline
external usenet poster
 
Posts: 4
Default 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?