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
Manipulating Text to create HLOOKUP
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="igorek, post: 3783624"] Yes, the simlest way to do it is not using lookup but put together a pivot table. In the firt column put dept id and in the second your employee id. Get rid of subtotals thereafter. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Manipulating Text to create HLOOKUP
Top
