Hi,
I have 2 different excel workbooks and trying to use Vlookup formula.I wish to extract the information when the dates match.However, I'm getting error (NA)-The reason I suspect is that the dates are in different format in both the sheets. I cannot change format in the first excel(attached-Excel1) because it comes from running a program. How can I change the format in (attached- Excel2)-to fix this error please? Ive used Text to Columns method but its not helping. Would request someone to kindly help me fix this!
Thanks.
Bookmarks