I have a bunch of categories;
All have variable amounts - except for category
Ghost, the amount is always
I have Data Validation set up (which is how I pick the category). I want to automate that when I pick
Ghost as my category, it auto fills in the next cell (in Column B) with the amount
Is this possible in Google Sheets?
Note, my other categories can and do have variable numbers (including negatives).
Update: I'm hoping it'll ignore other cells which aren't in the
Ghost category in row A.