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
what function/formula do I use?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Roger Govier, post: 3764268"] Hi Kate Assuming employee numbers are unique, and entered in column A of Sheet1, with scores in columns B through M On Sheet2 in cell B2 =IF($A2="","",VLOOKUP($A2,Sheet1!$A:$M,COLUMN(),0)) You can then drag this formula across through C2:M2, and then down as far as required. Change the ranges to suit your situation. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
what function/formula do I use?
Top
