Need Help with NESTED VLOOKUP for DATES

Hi Excel Gurus, I'm hoping someone might be able to help me with my janky formula:
=IF($B2="","",IFERROR(TRIM(VLOOKUP($B2,'sheet1'!$A$1:$DK$5000,COLUMN(J$1),FALSE)),""))

ISSUE: For columns in sheet1 that contain DATES, vlookup is returning GENERAL numbers.
I read online that I could troubleshoot this by adding a TEXT formula, so I assume it should look like this:
=TEXT(VLOOKUP($B1,'sheet1'!$A$1:$DK$5000,COLUMN(J$1),FALSE),"MM/DD/YYYY")

PROBLEM: I'm not sure how to incorporate that TEXT formula into the mess I already have above.

---------
Overall purpose/goal (in case it would help):
I'm trying to take a random list of item numbers (column B; some of which are missing and will be filled in at various times) and search for all of the info (i.e. columns A:DK in sheet1) that matches that item number.
Some information in sheet1 maybe missing and if so, I'd like vlookup to return them as blank (vs. 0).

And if anyone happens to have recommendations for a better (and shorter) formula, I'd be open and grateful for the feedback.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"