Lookup in a different worksheet based on an entered field
Posted by Amy on September 28, 2001 6:53 AM
I have 12 worksheets labeled January - December.
On another worksheet I want the user to enter a month in cell F4 (through a list I created with data validation) and have the formula lookup a value in the corresponding worksheet.
Once the month worksheet is determined, i was going to use the VLookup formula to find "Department" in the first column of the table labeled "Name" and return the corresponding value in the column W labeled "TSF"
I cannot get the VLOOKUP function to work even when I specify the month worksheet to go to.