=VLOOKUP(A1,Sheet1!A1:B100,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bob" wrote in message
...
In Sheet 1, Column A, I have a list of names of universities. In Sheet 1,
Column B, I have a list of numbers that correspond to the universities.

In Sheet 2, Column A I have the same list of names of universities. In
Sheet2, Column B, I want to place a formula that will search Sheet 1,
Column
A for the university name in that row and populate it with the
corresponding
value in Sheet 1, Column B.

Example:

Sheet 1
Column A Column B
Akron 14
Albany 22
Alabama 9
Boise State 17
Dayton 15

Sheet 2
Column A Column B
Dayton [formula that yields 15 as a result]
Albany ..
Alabama ..
Boise State ..
Akron ..

Can anyone Help?

Thanks,
Bob