Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Formulas
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Gord Dibben, post: 3453231"] Tim Sheet1 Column A contains suite numbers. Sheet1 Column B contains tenants. Sheet2 A1 is where you enter a suite number that would be on Sheet1. Sheet2 B1 enter =VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE) Sheet2 B1 will return the tenant associated with the number you enter in A1 Gord Dibben XL2002 [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Formulas
Top
