Compare data and automatically enter data.

T

Tesa M.

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?
 
T

Toppers

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,"",VLOOKUP(siteNumber,Sheet2!A:B,2,0))

HTH
 
Top