Hello again,
Hello All,
Asking for help again in this hypothetical group of employees. There are three worksheets
Worksheet 1 is list of employees who worked in this company by office code in 2023.
Worksheet 2 is list of employee who worked in this company by office code in 2024.
Worksheet 3 is list of all employees who ever worked in this company.
I am trying to look at worksheet 1 and if the employee worked in this company in 2023, look at worksheet 3 and put either a Yes or No in column C beside their name. Same for worksheet 2, if they worked at the company in 2024, look at worksheet 3 and put either a Yes or No in column D beside their name.
Any thoughts ?
The excel file size was too big apparently to attach.
Respectfully
Brian
Looking at three workbooks at once
-
- NewLounger
- Posts: 11
- Joined: 12 Feb 2019, 14:25
Looking at three workbooks at once
Last edited by brianwhorton on 25 Feb 2024, 00:35, edited 1 time in total.
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Looking at three workbooks at once
If you only want to match by name:
In C2: =IF(COUNTIF('2023'!B:B, B2), "Yes", "No")
In D2: =IF(COUNTIF('2024'!B:B, B2), "Yes", "No")
If you want to match by office code and name:
In C2: =IF(COUNTIFS('2023'!A:A, A2, '2023'!B:B, B2), "Yes", "No")
In D2: =IF(COUNTIFS('2024'!A:A, A2, '2024'!B:B, B2), "Yes", "No")
Fill down.
In C2: =IF(COUNTIF('2023'!B:B, B2), "Yes", "No")
In D2: =IF(COUNTIF('2024'!B:B, B2), "Yes", "No")
If you want to match by office code and name:
In C2: =IF(COUNTIFS('2023'!A:A, A2, '2023'!B:B, B2), "Yes", "No")
In D2: =IF(COUNTIFS('2024'!A:A, A2, '2024'!B:B, B2), "Yes", "No")
Fill down.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 11
- Joined: 12 Feb 2019, 14:25
Re: Looking at three workbooks at once
Is there a way to donate or some way to support this page?
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Looking at three workbooks at once
That is very kind of you, but that is not necessary. The sentiment is appreciated, though!
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 11
- Joined: 12 Feb 2019, 14:25
Re: Looking at three workbooks at once
Ok Hans . Thanks, but you did some calculations for me in minutes that a worked a few hours on a couldn’t make work.