Lookupvalue in 3 columns based on same date/key

Hello,

i am struggeling with this issue in PowerBI.

I am creating headcount tables in my company for attendance rates.

i need to add value of Cell unit  to employees.

I have two tables, unique per each year_month.

1) Cell - including fields:

Year_Month

ID

Cell unit

Key1 (=ID + YEAR_MONTH)

2) HC - including fields:

Year_Month

ID 1 

ID 2

ID 3

KEY1 (=ID1 + YEAR_MONTH)

Both tables are connected via Key1

What i need to do ?

In HC table create calculated column, that returns value of Cell[Cell unit] field, if Cell[ID] is found in HC[ID1] or HC[ID2] or HC[ID3] - but it has to be searched only within each Year_Month (so search Cell[ID] from 2021_01 in HC[ID1]  from 2021_01) and so).

In input data, Cell[ID] can be found only in one column per each row in Headcount Table.

I tried searching and typing different formulas including If, vlookupvalue and so but none of the worked. I got return the values but it was vlookuping them ignoring the Year_Month.

Can anyone help me please ? Thank You