| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Data
Worked it out myself thanks.
-- Newfie "Newfie809" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning data | Excel Worksheet Functions | |||
| Returning value from a range of data | Excel Discussion (Misc queries) | |||
| Vlookup returning No data. | Excel Worksheet Functions | |||
| Find and returning data. | New Users to Excel | |||
| Finding, and returning data. | New Users to Excel | |||
Hybrid Mode
