'Transactions' tab 'Group' category Error issue

Google Sheets
1

I’m making a new spreadsheet to replace my 2023 version, it became too riddled with issues so I’m starting fresh. On the ‘transactions’ tab I have added a ‘group’ column as per the instructions listed here:

The ‘group’ column is able to properly reference the ‘category’ column and the text string is fine. However, I still get the following error message:
-Red triangle in the top right corner of the cell with the note…
-Invalid: Input must fall within specified range

2

Try this formula instead, and just edit the columns where applicable.

=ARRAYFORMULA(IFERROR(VLOOKUP(D:D,Categories!A:B,2,FALSE),IFERROR(1/0)))
3

I fixed it using ‘Data validation’ from this:

4

My guess is that you inserted a Transactions sheet column when the Category column was selected, which would copy the Category column data validation rules.

If so, delete the column you added and insert a column elsewhere.

1 Like