keithcomic
New Member
- Joined
- Jul 10, 2008
- Messages
- 4
Is there any way to create a VLOOKUP formula where a reference in the formula will change based on the contents of a certain cell? The formula needs to change.
For example: I create labor reports for my company. Each labor report is labeled as such
LABOR REPORT 20080710
The next days report will have that days date at the end.
For example:
LABOR REPORT 20080711
I want to create a formula that looks up a certain range based on a cell containing the title of the sheet.
I would want to enter 20080711 in a cell in a separate sheet and have the VLOOKUP formula change from
=IF(B7>0,VLOOKUP(B7,'\\Inet\Data\peg-users\Pegasus\17 Databases\LABOR REPORT 20080710xls'!EmpList,2,FALSE),"-")
to
=IF(B7>0,VLOOKUP(B7,'\\Inet\Data\peg-users\Pegasus\17 Databases\LABOR REPORT 20080711xls'!EmpList,2,FALSE),"-")
so that the reference now refers to the new sheet title.
Is there any way to do this?
For example: I create labor reports for my company. Each labor report is labeled as such
LABOR REPORT 20080710
The next days report will have that days date at the end.
For example:
LABOR REPORT 20080711
I want to create a formula that looks up a certain range based on a cell containing the title of the sheet.
I would want to enter 20080711 in a cell in a separate sheet and have the VLOOKUP formula change from
=IF(B7>0,VLOOKUP(B7,'\\Inet\Data\peg-users\Pegasus\17 Databases\LABOR REPORT 20080710xls'!EmpList,2,FALSE),"-")
to
=IF(B7>0,VLOOKUP(B7,'\\Inet\Data\peg-users\Pegasus\17 Databases\LABOR REPORT 20080711xls'!EmpList,2,FALSE),"-")
so that the reference now refers to the new sheet title.
Is there any way to do this?