Looking at three workbooks at once

[brianwhorton]

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

[HansV]

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.

[brianwhorton]

Is there a way to donate or some way to support this page?

[HansV]

That is very kind of you, but that is not necessary. The sentiment is appreciated, though!

[brianwhorton]

Ok Hans . Thanks, but you did some calculations for me in minutes that a worked a few hours on a couldn’t make work.