HOW TO FIX THIS ERROR UPLOOKX MULTIPLE CRITERIA

Hi @Eduardo Emura,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your sharing, I have imported the data into my worksheet, and the formula is working correctly as you can see below (date format in my worksheet is mm/dd/yyyy) so your formula logic is correct. Therefore, I believe the issue is due to one of the cells is not in correct format.

For a quick check, I suggest you can use the CONTAR.SI.CONJUNTO formula to see if any row matches:

=CONTAR.SI.CONJUNTO(LIQUIDACIONES!$B:$B;"LEGADO";LIQUIDACIONES!$C:$C;U2;LIQUIDACIONES!$A:$A;">="&T2;LIQUIDACIONES!$A:$A;"<="&T3)

If it returns 0, the BUSCARX is correctly returning error #N/D. Then you need to double check all the cells and range used in the formula and ensure they are in correct format for example, check T2 and T3 are both correctly as date not text, U2 is correct as number, etc.

I hope this helps you move forward smoothly. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.  

Thank you for your patience and understanding. Looking forward to your response.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".       

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.