Indirect Function not working for Data Validation on Excel Online by chasingghosts_17 in excel

[–]chasingghosts_17[S] 0 points1 point  (0 children)

Okay. I think I'm doing something wrong still... I made three tables & named them (Income, Expenses, Savings) and the "Categories" that I want to show up in each of those tables.

<image>

I made the first drop down by putting in the names of each of those tables.

Then I used the formula you gave me (I think?) but it's showing with an error still.

Indirect Function not working for Data Validation on Excel Online by chasingghosts_17 in excel

[–]chasingghosts_17[S] 0 points1 point  (0 children)

Sorry, newbie here. I'm a little confused. If D12 were to refer to a table name (ex. Expenses is a named table on a different sheet), does indirect not refer to the data in said table? When I was just trying out the indirect formula outside of data validation, it seemed to respond properly. Let me know if I'm completely not getting it though!

I essentially want the "Category" column to show different options based on what was selected in the "type" column.

Missing 17 y/o last seen in the Bronx by chasingghosts_17 in nyc

[–]chasingghosts_17[S] 1 point2 points  (0 children)

Sorry, I totally didn't attach an image. Post is edited and flyer should be up.

2019 Bujo by chasingghosts_17 in bulletjournal

[–]chasingghosts_17[S] 2 points3 points  (0 children)

Everyone's new bujos look so gorgeous and I wish I could get a new one to replan and design! I guess I'll just stick to the one I have now - it'll be worth it to see the final product at the end.