title: Same as vlookup but cloumn number is changing everyday
body: <p>I am new to excel macros.I have Sheet1 and Sheet2. Both the sheets have Project Id as common. I have columns in sheet1 as cd1 and cd2 which are same as cd1 and cd2 in sheet2 but values are not in order. I can do VLOOKUP here but the cd1 and cd2 might be changing.In sheet2 the column Cd1 was in Column X yesterday  and now it is in Column Z. My problem is if I do Vlookup here then i have to change all the column numbers and column name everyday. Is there any pocedure that I track those values using Column Names??</p>
  
  <p>I think this is simple but don't know how to do it. Thanks in Advance.<a href="http://i.stack.imgur.com/YkSHi.png" rel="nofollow">Sheet 1 and Sheet 2</a></p>