I have two columns with information. Values in Column B have been manually added to match the values in Column A.
Is it possible to have a function that auto-populates column B with the right values based on what comes before the new rows (i.e 998, 999)?
Column A might have a different order each time new rows get added.
A B Product Category 1 Apple Fruit 2 Orange Fruit 3 Beets Vegetable 4 Cake Dessert 5 Carrot Vegetable 9 Apple Fruit ... 998 Beets ? 999 Apple ?
Is this possible in Google Sheets?