So I have two sheets,
shoppingList. I have data validation in my
shoppingList which is bound to a column in the
In the master ingredient sheet, there are costings in lets say column 'G'. So if the user selects Onion in
shoppingList, in the adjacent column I'd like to get that cost for that ingredient.
I've tried to search but to no avail.