Forum Discussion

Sbain2150's avatar
Sbain2150
Copper Contributor
Mar 17, 2021

Labor and Travel Calculator

Ok SuperUsers I need your help.  I have attached a spreadsheet that I use to track travel and labor costs but I need some help.   Starting with the Travel Schedule Tab: this tab is where the majori...
excel
Formulas and Functions
chahine's avatar
chahine
Iron Contributor
Mar 18, 2021

Sbain2150 please find my solution using indirect so it will be dynamic , i called some tables in the form of FY_21 etc, then used indirect to refer to this, hope this helps

Sbain2150's avatar
Sbain2150
Copper Contributor
Mar 18, 2021
chahine This will not work because I use the tables from the Tables tab to use as a drop down on the Calculator tab for the reason. So I need the following to link to the FY_21: the reason, destination and rate.