Solved: Lookup, Concatenate & Format Date

[zest1]

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.

[zest1]

Solved my own problem, but thanks anyway.

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

[Ken Puls]

Nice work, Zest!

I'll mark the thead solved since the Thread Tools aren't working.