DashboardNovice
Member
When press Ctrl + Shift + Enter, I get the #VALUE! error.
Can anybody tell what is causing this error? I have been able to determine that is it within the array of the MATCH function.
Code:
{=INDEX(tblProjectQuery[[#Headers],[Project ID]],MATCH(CONCAT('Existing Projects'!A3,'Existing Projects'!B3,'Existing Projects'!C3,'Existing Projects'!D3,'Existing Projects'!E3,'Existing Projects'!F3,'Existing Projects'!G3),tblProjectQuery[[#Headers],[Level 1]]&tblProjectQuery[[#Headers],[Level 2]]&tblProjectQuery[[#Headers],[Level 3]]&tblProjectQuery[[#Headers],[Level 4]]&tblProjectQuery[[#Headers],[Level 5]]&tblProjectQuery[[#Headers],[Level 6]]&tblProjectQuery[[#Headers],[Level 7]],0),1)}
Can anybody tell what is causing this error? I have been able to determine that is it within the array of the MATCH function.