Vlookup Formula

[Martin9]

Hi I am trying to create a lookup that will change when I change a patricular cell, what I currently have is a vlookup formula that that finds a value for each line based on the site name, and then the column I want it to look at, but I was trying to create a formula that instead of looking at a column number it can find a word such as a month and then find the figure in that column, for example if column a has the site name and in cell b2 has the current month and "tab2 has all the raw data by month, can I create a formula in column c that will find the site name and then look on "tab 2" for the relevant month? Or will I have to change the formula every month?
Regards
Martin

[dilipandey]

Hi Martin,

I would suggest you to explore the Index - match formula...
Supply the sample workbook in case of any issues. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[martindwilson]

without seeing your data have a look at index/match or you could use match in the vlookup to find the col entitled month
say your data is in d1:h10 and colum f cell f1 has "month"
vlookup("something",d1:h10,3,false)
can become
vlookup("something",d1:h10,match("month",d1:h1,0),false)