My apologies, I made some changes to the cell references when I was trying to get the formula working and I forgot to change them back.

=vlookupx(A13,ULD!$A:$D,2,0,COUNTIFS($A13:$BB13,A1 3,J17:AY17,A13,G26:U26,A13,AE26:AP26,A13))

Note that your original formula was logically correct - it just had a few syntax errors. In particular the parameters of the two functions must be separated by commas ',' and contained within a set of ()'s so the formula needs to take this form...

=vlookupx( <cell containing lookup value> , <range of cells to lookup in> , <column number to look up> , <0 or 1> , COUNTIFS( <range of cells 1> , <criteria for range of cells 1> , <range of cells 2> , <criteria for range of cells 2> , ... ))