I have a spreadsheet that requires me to see the status of every employee. What I want to do is just to type their employee number and all information and status regarding with this employee should appear next to the number i type. My database is on other sheet while I want to work on the other sheet. A formula or hyperlink can do this job? Any help will be appreciated. Thanks.
Last edited by bokals; 06-23-2009 at 06:52 AM. Reason: wrong post title
Thank you for altering your title - both mdw & squiggler have solutions for you I believe so I will leave to them...
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This should work for you
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Thank you squiggler47 your formula solved my problem. Thanks also to the moderator for the corrections of my mistakes. Your help is very much appreciated. God Bless all
Greetings,Originally Posted by squiggler47
Your formula did great on my work, however i forgot to include 1 column in the worksheet. could you pls. help me again. also how can I add the number under the employee no? it seems that it is only limited to 21. If I put additional employee I cannot find their number
thanks in advance
I made the changes, the Employee number Take into account up to 65000 items! Just add below!
Regards
Darren
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
hi.
The changes was great I was able to put additional rows on my worksheet but the only problem I have is with in the column. I added two columns and I tried to copy your first formula and paste it to the new columns, but it doesnt work, How am i going to do it? I uploaded the new worksheet. Thanks again for your help
I made a change which allows the formula to be copied, but oly if the columns on your employees sheet are in the same order as the Status sheet!
the formula is
=IF(INDEX(' Employees'!$A$5:$G$65000,MATCH($B7,EmployeeNumber,0),COLUMN())<>"",INDEX(' Employees'!$A$5:$G$65000,MATCH($B7,EmployeeNumber,0),COLUMN()),"")
If you want to change it to refer to columns out of order change both column() in red to the number of the column you want A=1 etc!
Hope this helps
Regards
Darren
Regards
Darren
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
thank you once again i'll try to work with new column and i wll let you know if I encountered error. God Bless
well its great to be here ....i am learning a lot from this forum ....actually i am an accountant in a printing company and i have such a kinda same problem ....well the problem is solved by this formula thanks for the help ...
Last edited by larycom; 06-25-2009 at 09:04 AM.
I need a formula that would say if any values in column A of sheet1 are found within column C of sheet 2, then give me the value for sheet2 column F for that record that is found in sheet 2 column C.
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
Please take the time to read the forum rules.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
it's So Easy just open the Excel sheet where your Actual Employee data then go to the Next sheet and wrote =Sheet1!B2 or which data u required on Sheet 2 it's Automatic link with both sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks