Referencing a column across worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=VLOOKUP(A1,Sheet1!A1:B100,2,False)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need VLOOKUP to Work Two Ways 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
Refernce 2 sheets & same columns & rows 8
Using SUMIF with dates 11
Figuring out a lengthy formula. Probably quite simple... 3
Splitting data from one spreadsheet into multiple spreadsheets 2
Creating a dynamic IF statement 2
Criteria to return maximum value where x = x 3

Back
Top