Hi Everyone,
I am trying to use Vlookup to automate a file based on the selected month. So for instance I have setup cell B3 as a drop-down list. The list contains the abbreviated months Jan to Dec, and my other sheets are named the same as these options. So now I want to use cell B3 as the sheet that VLoopup will select the array from.
So my test is setup to select "Jan" by clicking on that tab, which is ok, but if I want to look at Feb next, it doesn't change because it isn't linked to the input cell with the different months.
=VLOOKUP("Test",Jan!A1:N35,2,1)
I cannot get any indirect function to work, below is an example of selecting the cell B3 as the sheet for the array (which is obviously wrong). Can anyone help me figure out what I need to put in here to select the sheet based on the cell input?
=VLOOKUP("TEST",'B3'!A1:N35,2,1)
Bookmarks