ExcelBanter - Returning Data to an empty Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Returning Data to an empty Cell (https://www.excelbanter.com/excel-worksheet-functions/199890-returning-data-empty-cell.html)

Newfie809

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

Newfie809

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

All times are GMT +1. The time now is 05:20 PM.