XLOOKUP OR IF(AND or something else?

[James8761]

Hi,
I think I am complicating things but I've been trying for a while, so time to ask for help....

I have two tabs on a workbook. Data and Lookups. On the Lookups tab I am trying to look at if an employee was working in Jan 24, Feb 24 etc, then VLOOKUP a table and return a value.

Answers from my current formula are in Cells Q34:V115.
The correct answers are in Cells Q119:V120 (typed in).



The formula in Cell Q34 is

The Data Columns I am looking at are;

Does anyone have any idea how i can get this to work please?

Thanks,
James

 

[hagia_sofia]

Hello, maybe something like:

=IF(SUM((Data!$S$2:$S$1000=$P34)*(Data!$P$2:$P$1000=Q$33)),XLOOKUP(Q$33,$P$8:$P$13,$Q$8:$Q$13),0)