Forum Discussion
markjoyus
Oct 07, 2019Copper Contributor
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...
- Oct 08, 2019
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!
markjoyus
Oct 07, 2019Copper Contributor
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.
Genevieve Volkers
Oct 08, 2019Copper Contributor
How about resaving that file and choose specifically the .xlsx format? markjoyus
- markjoyusOct 08, 2019Copper Contributor
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!
- datphamictFeb 01, 2021Copper Contributor
Please read it, It can help you
Hướng dẫn sử dụng https://tinhocvanphong.net/huong-dan-su-dung-ham-vlookup-trong-excel/