I have 2 worksheets, both with columns for "Site Name" and "Site Number".
Both have site numbers filled in - only one has site name filled in. How do
I get Excel to automatically search for the site name on one worksheet and
input that info. into the other worksheet?