I have a file with about 10 worksheets, each one has a name of an employee. One of the sheets contains all the info about the employee. On this main sheet I would like a cell to reference a named worksheet which matches the names that appear in the main sheet list. From that worksheet I would like a formula that gives me the score referenced from each individuals sheet. I have attached a small example file
Thanks
Using the example, this in K3:
Formula:
Please Login or Register to view this content.
Returns 0, when G95 on Eric sheet is changed to another number, it returns that number
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Really, that's it? I have been wasting all kinds of time to figure this out. You are a lifesaver.
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks