| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Data | Excel Worksheet Functions | |||
| Returning data | Excel Worksheet Functions | |||
| Returning value from a range of data | Excel Discussion (Misc queries) | |||
| Find and returning data. | New Users to Excel | |||
| Finding, and returning data. | New Users to Excel | |||
Threaded Mode
