I have attached a sample workbook that uses two left joins. First, in the Excel sheet, in the reference table tab, I changed the Years column to General or Number.
Then, within Tableau, connect to the Excel sheet and select Multiple tables. Data for scenario should be the primary table. Then, Add Table...-->reference table. On the join tab, select a Left join type. In the join clause, add Calculated in Tableau_years since age 20 = years. Click OK, and OK.
Add a second Table, adding the reference table again. Once again,
select a Left join type. In the join clause, add Calculated in Tableau_years worked = years. Click OK, and OK.
Then, created two calculated fields to get the desired result. Refer to the Years since age 20*Multiplier and Years Worked * Multiplier calculations.
Hope this helps!
Vlookup, aka left joins.twbx.zip 58.0 KB