'Invalid' Error Message on Transactions Page

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.

My guess is that you inserted the new Group column when the Category column was selected and so your Group column inherited the Category column’s data validation.

Delete your Group column and try inserting a new column by selecting a column that has a similar format - Group is text, so also not Date or Amount for example.

1 Like