2 criteria vlookup from messy (less messy) payroll file

Hi, i sent an email previously that was attempting the same request but from a much messier data source.
I have resulted in a couple of tidy steps, but now I require to match 2 critera in another Tab to display a result, but I think this time its easily achievable
I have tried quite a lot of examples but i don't seem to be able to get this to work.

for tab 'Daily Export' C4 I need a formula that checks both statements below and only displays if both correct, I realize its likely an index/match formula to replace the to vlookups but I can't manage to make it work.
could someone please help me I would greatly appreciate it

=VLOOKUP(B1,DL!D:V,19,FALSE)
=VLOOKUP(A4,DL!A:V,22,FALSE)

Another option:
In Cell B4, then copy over and down:

=XLOOKUP($A4&OFFSET(B$1,0,-MOD(COLUMN(),2)),INDIRECT(B$3&"!A:A")&INDIRECT(B$3&"!D:D"),INDIRECT(B$3&"!V:V"),"",0)

Many ideas..

Formula:

=XLOOKUP(1,(B$1=SL!$D:$D)*($A4=SL!$A:$A),SL!$V:$V,"",0,1)

Formula:

=XLOOKUP(1,(B$1=DL!$D:$D)*($A4=DL!$A:$A),SL!$V:$V,"",0,1)

I didn't find 'Daily Export'!B5

"I didn't find 'Daily Export'!B5"
DJunqueira - That's because "Person2 " on the SL sheet has a space at the end :-(

Originally Posted by Gregb11

"I didn't find 'Daily Export'!B5"
DJunqueira - That's because "Person2 " on the SL sheet has a space at the end :-(

Yes, you are right!

Solving this problem:

Formula:

=XLOOKUP(1,(B$1=SL!$D:$D)*($A4=TRIM(SL!$A:$A)),SL!$V:$V,"",0,1)