Problem: My formula to lookup (using INDEX / MATCH) to pull in date values from one workbook to another appears to be working correctly, but some dates just pull in and convert to zero and I'm not sure why?
What I'm trying to do: Is save time rather than copy manually all these over.
The formula in right table 'Custom Field (Actual end)": =IF(MATCH([@[Issue key]],MetricsCapture.xlsx!Table1[Issue key],0),INDEX(MetricsCapture.xlsx!Table1[#Data],MATCH([@[Issue key]],MetricsCapture.xlsx!Table1[Issue key],0),78),"")
Pulling data from the table on the left to the table on the right using that formula:
What I'm trying to do: Is save time rather than copy manually all these over.
The formula in right table 'Custom Field (Actual end)": =IF(MATCH([@[Issue key]],MetricsCapture.xlsx!Table1[Issue key],0),INDEX(MetricsCapture.xlsx!Table1[#Data],MATCH([@[Issue key]],MetricsCapture.xlsx!Table1[Issue key],0),78),"")
Pulling data from the table on the left to the table on the right using that formula: