hello Peter, I have tried the formula as you passed it but I still get the #VALUE error. Why is that that in the formula you refer to A1? and... why don't we refer to the ULD! sheet anymore? I ask you these questions because I would like to learn from this.

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> , ... ))