Hello. I have two named tables LaborForecastHours and LaborForecastCost.
I want to cross reference two columns [Task] and [Employee Name] (same in both tables) using a Match function to return the row in LaborForecastHours that matches the current selected row in LaborForecastCost.
I've tried the following, but keep getting an error. It is important that the formula used is dynamic and doesn't require a certain order. There is only one Employee Name per task and two tasks total. I want the formula to continue to work if rows with more tasks or employees are added.
This is what I tried:
=Match(1,(LaborForecastHours[Task]=[@Task]*(LaborForecastHours[Employee Name]=[@Employee Name]),0)
I get a #Value error when Excel evaluates LaborForecastHours[Task] and LaborForecastHours[Employee Name] instead of it converting the structured reference to a range. All the structured references are colored and recognized, so I'm at a loss as to what the issue might be.
I want to cross reference two columns [Task] and [Employee Name] (same in both tables) using a Match function to return the row in LaborForecastHours that matches the current selected row in LaborForecastCost.
I've tried the following, but keep getting an error. It is important that the formula used is dynamic and doesn't require a certain order. There is only one Employee Name per task and two tasks total. I want the formula to continue to work if rows with more tasks or employees are added.
This is what I tried:
=Match(1,(LaborForecastHours[Task]=[@Task]*(LaborForecastHours[Employee Name]=[@Employee Name]),0)
I get a #Value error when Excel evaluates LaborForecastHours[Task] and LaborForecastHours[Employee Name] instead of it converting the structured reference to a range. All the structured references are colored and recognized, so I'm at a loss as to what the issue might be.