Replacing Vlookup Formula witha more efficient substitute

[Kearnd967]

Good morning, We have a number of large spreadsheets which are full of vlookup formulas between multiple workbooks. I have started replacing them with Index Match and this has worked really well. We have a scenario where Index match doesn't seem to work, and i would like some advise on a more efficient formula to use in the situation. We need the vlookup function to use the number of columns accross that is available on the third part of the lookup formula.

At present the formula we use is
VLOOKUP(B15, 'Actual 2015'$B$7:$IW$69994, ($c$1+$AB$3),0)

The spreadsheet in question is a summary sheet showing YTD financial information
Actual 2015 is financial info for the year broken down by month
B15 is a material Code
C1 is the month
AB3 is the a number row that runs across the top of the summary sheet.
(C1 and AB3 make up the lookup number in the other sheet)

I look forward to your creative answers!
David.

 

[ExcelGuyDude]

Why doesn't Index/Match work?

=INDEX(OFFSET('Actual 2015'$B:$B,,$C$1+$D$1-1),MATCH(B15,'Actual 2015'$B:$B,0))

 

[Kearnd967]

That works perfectly, thank you. Didnt think about offsetting!!!