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.