|Sounds like VLOOKUP might work, but how will you deal with 2 families that have the same last name or families that have more than 1 child?|
As per the Excel help files, the syntax is:
Normally you would use the col_index_num of the table_array to pull the grade, teacher, etc. based on the lookup of the last name.
The problem is going to be in those situations where you have 2 or more families with the same last name or more than one kid per family.
VLOOKUP is going to find the first occurance of the last name and ignore all others.
That problem is going to exist even if you code something in VBA, unless (in both cases) you can create a column that contains something unique to each family to key off of.
Based on the data below, which kids belong to which parent and vice versus?
Smith, Tom, 5, Mr. Magoo
Smith, Sue, 6, Mr. Peabody
Smith, Bobby, 6, Mr. Peabody
Smith, Fred, 213-456-7890, 123 One St
Smith, Barb, 213-987-6543, 456 Two St
You need a "family key" as a starter and then we can take it from there.