I have the following columns on a spreadsheet
1 ITEM LOCATION EXISTS? 2 apple 3 3 banana 6 TRUE 4 fish 9 5 dog 6 cherry TRUE 7 goat 8 horse 9 chicken TRUE
The LOCATION column is a list of row numbers pertaining to ITEM.
I'd like the EXISTS column to be marked as TRUE for the row number listed in the LOCATION column.
I'm really stuck and would appreciate some guidance.