I’m doing a lookup and returning a value into B2 and concatenating it with a date from E2, but am having trouble getting the date to display in 2-digit year format rather than the 5-digit date number. How do I change the following formula to display the concatenated date in a 2-digit format.

=VLOOKUP(B2,Sheet3!G3:J22,2,0)&E2(“yy”)

I appreciate any help with this.
Thanks.