Returning data
 

I posted a question on Excel yesterday called returning data and I never
received any response can anyone help me???????????????????????

--
Newfie

Returning data
 

Newfie809 wrote:
I posted a question on Excel yesterday called returning data and I never
received any response can anyone help me???????????????????????


You need to provide a more complete description of how your data is stored.
Also, you mention a formula that is working...you should provide that as well.

Returning data
 

Have you thought about using VLOOKUP? If each of the worksheets have the
employee name, all you have to do is write a different VLOOKUP for each field
you want. Eg. say you want your location of the employee in range B5 and B1
contains the name of the employee. Put the following in B5.

Assuming the name/location of the employee is in Sheet 9 with name in A1 and
location in B1...

=VLOOKUP($B1,'Sheet9'!$A$1:$B$27,2,FALSE)

Note: to use vlookup, the unique identifier (name of the employee) must be
in the left-most colum of the range used for the second criteria in the
VLOOKUP function. For additional information on VLOOKUP search help for
VLOOKUP.

Hope this helps!
--
-SA


I have a workbook with 10 or more worksheets. At the end I would like to
have a list of the Employees there FTE and their location etc. My formula to
return the FTE works but I cannot seem to get the formula to return there
location. What I want it to do is look up the Employee's name and check what
their location is and return the data to that cell next to their name. Can
you help?

Worksheet 1 has the name of the employee in C3 and say Worksheet 5 has there
location in A1 and Worksheet 9 has there FTE in G5 I would like to have all
the data on one sheet for reports. All worksheet's will have there name. What
I am trying to do is combine it all on one spreadsheet. Each sheet will have
the Employee's name. It's like the 10 sheets is the Data Warehouse and I
would like to do a report from it.

Thanks


--
Newfie


"Newfie809" wrote:

I posted a question on Excel yesterday called returning data and I never
received any response can anyone help me???????????????????????

--
Newfie

Returning data
 

this works. thanks

--
Newfie


"StumpedAgain" wrote:

Have you thought about using VLOOKUP? If each of the worksheets have the
employee name, all you have to do is write a different VLOOKUP for each field
you want. Eg. say you want your location of the employee in range B5 and B1
contains the name of the employee. Put the following in B5.

Assuming the name/location of the employee is in Sheet 9 with name in A1 and
location in B1...

=VLOOKUP($B1,'Sheet9'!$A$1:$B$27,2,FALSE)

Note: to use vlookup, the unique identifier (name of the employee) must be
in the left-most colum of the range used for the second criteria in the
VLOOKUP function. For additional information on VLOOKUP search help for
VLOOKUP.

Hope this helps!
--
-SA


I have a workbook with 10 or more worksheets. At the end I would like to
have a list of the Employees there FTE and their location etc. My formula to
return the FTE works but I cannot seem to get the formula to return there
location. What I want it to do is look up the Employee's name and check what
their location is and return the data to that cell next to their name. Can
you help?

Worksheet 1 has the name of the employee in C3 and say Worksheet 5 has there
location in A1 and Worksheet 9 has there FTE in G5 I would like to have all
the data on one sheet for reports. All worksheet's will have there name. What
I am trying to do is combine it all on one spreadsheet. Each sheet will have
the Employee's name. It's like the 10 sheets is the Data Warehouse and I
would like to do a report from it.

Thanks


--
Newfie


"Newfie809" wrote:

I posted a question on Excel yesterday called returning data and I never
received any response can anyone help me???????????????????????

--
Newfie