I’m starting a new Google sheet for 2025. On my ‘Transactions’ tab I have ‘Group’ in Column D and ‘Category’ in Column E. For all of the ‘Group’ cells I get a red triangle at the top right of the cell and it gives this as an error message:
Invalid:
Input must fall within specified range
This is the formula for the ‘Group’ column typed in cell D1.
=arrayformula(if(row($E$1:$E)=1,“Group”,iferror(vlookup($E$1:$E,{indirect(“Categories!$”&SUBSTITUTE(ADDRESS(1,MATCH(“Category”,Categories!$1:$1,0),4),1,“”)&“$2:$”&SUBSTITUTE(ADDRESS(1,MATCH(“Category”,Categories!$1:$1,0),4),1,“”)),indirect(“Categories!$”&SUBSTITUTE(ADDRESS(1,MATCH(“Group”,Categories!$1:$1,0),4),1,“”)&“$2:$”&SUBSTITUTE(ADDRESS(1,MATCH(“Group”,Categories!$1:$1,0),4),1,“”))},2,FALSE),“”)))
What do I need to do to get rid of the invalid error message? The sheet seems to be functional despite the error message.