Referencing a column across worksheets
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 |
Referencing a column across worksheets
=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 |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com