Compare data and automatically enter data.
 

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?

Compare data and automatically enter data.
 

Look at VLOOKUP function

=VLOOKUP(siteNumber,Sheet2!A:B,2,0)

"Sitenumber" on on Sheet1 e.g in a cell A1,and Columns A& B on Sheet2
contain Site Number/Site Name.

=VLOOKUP(A1,Sheet2!A:B,2,0)

To allow for errors:

=IF(ISNA(VLOOKUP(siteNumber,Sheet2!A:B,2,0)0,"",VL OOKUP(siteNumber,Sheet2!A:B,2,0))

HTH

"Tesa M." wrote:

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?