PDA

View Full Version : Solved: Lookup, Concatenate & Format Date



zest1
03-01-2006, 12:09 PM
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
03-01-2006, 12:50 PM
Solved my own problem, but thanks anyway.

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

Ken Puls
03-01-2006, 11:22 PM
Nice work, Zest! :)

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