hyperlink or formula

**bokals** · 06-23-2009, 04:36 AM

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.

**bokals** · 06-23-2009, 06:17 AM

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

**DonkeyOte** · 06-23-2009, 05:56 AM

Thank you for altering your title - both mdw & squiggler have solutions for you I believe so I will leave to them...

**squiggler47** · 06-23-2009, 06:01 AM

This should work for you

**bokals** · 06-23-2009, 08:54 AM

Originally Posted by squiggler47

This should work for you

Greetings,
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

**squiggler47** · 06-23-2009, 09:09 AM

I made the changes, the Employee number Take into account up to 65000 items! Just add below!

**bokals** · 06-24-2009, 01:07 AM

Originally Posted by squiggler47

I made the changes, the Employee number Take into account up to 65000 items! Just add below!

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