Referencing a column across worksheets

B

bob

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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