Filling In Cells Using Lookups Via VBA?

I've got a workbook that I've created via VBA.

One *** is populated with data that I want to look up and has
various ranges on it to use in .Validation on the other ***.

The other *** has .Validation in column 1 that looks up, for
instance, "FoodType".

Once the user has selected "Fruit", column 2's .Validation kicks
in and in that column the user sees a drop down list of "Bananas,
Oranges, Apples... and so-forth".

Once the user has selected a FoodType and a specific food, I want
to go to that table of lookup data that I created on the other
work***, use FoodType|SpecificFood as a unique key, and
retrieve a bunch of other cell values in the located row and use
them to populate corresponding columns in the *** where the
user specified FoodType|SpecificFood.

Can somebody point me in the right direction
strategy/syntax-wise?

For starters, I'm guessing that the code will be located in
Worksheet_Change and I'll be casing out on Target.Column.

But what do I do once that the "SpecificFood" column has
changed? Take FoodType and SpecificFood over to the
lookup ***... but what then?
--
PeteCresswell
.