Nel post news:Sullycanpara.2a4y3n_1151537104.1645@excelforu m-nospam.com
*Sullycanpara* ha scritto:

Hello,

I'm trying to create a spreadsheet for work to track employee check in
times for safety reasons.

What I am looking to do is have an employee open the safety
spreadsheet, and by inputting a tech's employee ID, to have it
automatically plot in his name, pager and manager (that would be
linked from another spreadsheet, the Tech List spreadsheet).

What I would like to know is how feasible/possible is it to create
something like this? I have intermediate/advanced excel skills, but
I'm just alright with formulas. I know I can link info from one book
to another, but what I'd like to do is when I input a tech's ID in
column A of the safety book, the formula searches the Tech List book
for the tech's ID, finds it, then reads the tech's pager, manager and
name from the same row as his ID would be on. How is this done?

Thanks for any help anyone can give, sorry if I haven't been totally
clear, let me know if there is any clarification needed!

Tim


Hi Tim,
I think the most suitable function for your needs is VLOOKUP. Check on line
help and try to use the function. If should have any problem, then post
again here.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy