Forum Discussion
Solved
Vlookup
I'm looking for dates in an Excel report to match dates downloaded from a web report and subsequently, bring back a value several rows over. A typical Vlookup function. I've tried formatting both col...
I tried saving as a .xlsm, a .xlsx and it didn't make any difference. However! I saved as a .txt and was able to copy and paste over the dates.
Thanks for your input!
Hi markjoyus ,
What type of formatting did you choose for both the columns? It may help to:
- Clear both columns of any formats and then
- Reapply the date format you want
- Use the Vlookup function with False (exact match)
Alternatively,
- Clear the columns of any formats and
- Use the Vlookup function based on the numbers (for those dates)
Hope this helps.
I can work with the data (dates) in the web report, but the data that is sent to me as a .xls file will not budge when I try to change the formatting.
How about resaving that file and choose specifically the .xlsx format? markjoyus
I tried saving as a .xlsm, a .xlsx and it didn't make any difference. However! I saved as a .txt and was able to copy and paste over the dates.
Thanks for your input!