Consulting

Results 1 to 3 of 3

Thread: Lookup, Concatenate & Format Date

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Dec 2005
    Posts
    99
    Location

    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.
    Last edited by Aussiebear; 06-26-2025 at 11:12 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •