I am creating a sheet to be used by our staff for vacation requests. I am
using drop down lists for them to choose name and department. I would like to
bring over information from another workbook that HR uses to compile time
available to each staff member to take off. I can reference individual cells
of course but I don't want to have a different sheet for each employee. Is
there anyway to make the reference dependent upon a variable? So if the
employee is me the reference will look for my name? I guess I looking for
something like IF THEN. Any ideas?

You sure can.. Use a VLOOKUP()

make sure you open the HR workbook and your current workbook in the same
instance of EXCEL, and just follow the definitions.

"Russell Hampton" wrote:

I am creating a sheet to be used by our staff for vacation requests. I am
using drop down lists for them to choose name and department. I would like to
bring over information from another workbook that HR uses to compile time
available to each staff member to take off. I can reference individual cells
of course but I don't want to have a different sheet for each employee. Is
there anyway to make the reference dependent upon a variable? So if the
employee is me the reference will look for my name? I guess I looking for
something like IF THEN. Any ideas?

I tried that too. I think I left something out. The other workbook that I am
trying to get information from has a separate worksheet for each staff
member. I need to be able to tell the cell to pull information from another
workbook but the only way that it will know which sheet to look at is by
reading the name from the first sheet. I think that I am trying to get
something done that can't be done.

"Sean Timmons" wrote:

You sure can.. Use a VLOOKUP()

make sure you open the HR workbook and your current workbook in the same
instance of EXCEL, and just follow the definitions.

"Russell Hampton" wrote:

I am creating a sheet to be used by our staff for vacation requests. I am
using drop down lists for them to choose name and department. I would like to
bring over information from another workbook that HR uses to compile time
available to each staff member to take off. I can reference individual cells
of course but I don't want to have a different sheet for each employee. Is
there anyway to make the reference dependent upon a variable? So if the
employee is me the reference will look for my name? I guess I looking for
something like IF THEN. Any ideas?