30 votes7 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Becky commented
Agree, the Microsoft website does say that if you have 365 version that you have this functionality but it is only available in Pro version and not the home version 365. I bring work home and we have not yet been approved to use excel 2013 Excel Pro. I'm tired of having to save things on a CD-R to bring home to work on and then save it to CD-RW to take it back to the office ( we can't save to a RW). When you have a lot of data (60,000+ lines) that you need to compare for duplicates in multiple spreadsheets in the workbook, it would be so nice to be able to do the compare electronically instead of having to do EVERY, SINGLE row.
740 votes123 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the votes! Based on your feedback/votes we’ve just announced the new XLOOKUP function. You can read more about it here: https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376Becky commented
Totally agree Vlookuo in 2010 version doesn't work as updates and patches are applied