-
Solved: Lookup, Concatenate & Format Date
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules