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?