hyperlink or formula

[bokals]

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.

[DonkeyOte]

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

[squiggler47]

This should work for you

[bokals]

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

[bokals]

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]

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

[bokals]

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

[squiggler47]

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

[bokals]

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

thank you once again i'll try to work with new column and i wll let you know if I encountered error. God Bless

[larycom]

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 ...

[wanetom]

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.

[DonkeyOte]

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.

[johntor]

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.