Forum Discussion
Vlookup
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!
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/