I have a workbook with a sheet "Lot Information" where the homeowners
name and lot number is listed:

Column A - Lot #
Column C - Owner Name


"Lot Information Sheet"
Column A -Home Owner
Name Column B - Lot #
Joe
Smith
A1
Ben
Jones
A2
Al
Baker
A3
Al
Baker
A4

I have another sheet called "Checks Received". What I want is "Checks
Received" sheet to look at the name from "Lot Information" sheet and
give me the lot #(s).

"Checks Received"
Column A-Homeowner
Name Column
B - Lot#(s)
Joe
Smith
A1
Ben
Jones
A2
Al
Baker
A3, A4

The problem I am having is a homeowner can and some do own several
lots. How do I set it so, it will find each lot owned?

Thanks

Hans