Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Data to an empty Cell
Worksheet 1 is called All Staff
Worksheet 2 is called TEAM 1 Worksheet 3 is called TEAM 2 All Staff A B C LOCATION EMPLOYEE # EMPLOYEE NAME 1 JOHN SMITH 2 RAY SMITH TEAM 1 A B LOCATION EMPLOYEE NAME DOWNTOWN OFFICE JOHN SMITH TEAM 2 A B LOCATION EMPLOYEE NAME CENTRAL OFFICE RAY SMITH I would like a formula to gather the location for each employee and return it to the All Staff worksheet. Thank you -- Newfie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning Data to an empty Cell
It's ok worked it out my self, thanks though.
-- Newfie "Newfie809" wrote: Worksheet 1 is called All Staff Worksheet 2 is called TEAM 1 Worksheet 3 is called TEAM 2 All Staff A B C LOCATION EMPLOYEE # EMPLOYEE NAME 1 JOHN SMITH 2 RAY SMITH TEAM 1 A B LOCATION EMPLOYEE NAME DOWNTOWN OFFICE JOHN SMITH TEAM 2 A B LOCATION EMPLOYEE NAME CENTRAL OFFICE RAY SMITH I would like a formula to gather the location for each employee and return it to the All Staff worksheet. Thank you -- Newfie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list from empty data cell source | Excel Worksheet Functions | |||
How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
Returning an empty cell when no data present | Excel Discussion (Misc queries) | |||
Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
Returning Data from a third cell in same row that meets two other | Excel Discussion (Misc queries) |