Hello Brilliant People Who Know Way More Than I Do,
Please see the attached example.
In cell B3, I use VLOOKUP to combine the date in B1 with a suffix depending on what was selected in cell B2. The expected result was 051515FLK but the date converts so the result is 42139FLK. How can I keep this from happening? Tried using DATE but got weird results so I did something wrong...
Thanks in advance!
Bookmarks