VLOOKUP question

Hi All,

Is there any way that I can adapt the following formula:

=VLOOKUP($G$2,'T:\Ski\COSTINGS\[OPS prices 2009.xls]Lift passes'!$D:$N,4,FALSE())/D24

Imagine
A1 = 2010

I want the formula to look up the workbook [OPS prices 2010.xls] instead of 2009

Thanks in advance for your help,
Steve

Here is a post on the subject:
Be sure to read the discussion, since there are more examples, tried and tested.

I would probably start with J-Walks Tip82 (copy and paste the code into: Alt+F11, Insert, Module).
HTH
Ola