Not many of us use VLOOKUP to the full extent; yes, I say full extent because there is a lot more beyond traditional VLOOKUP, and we can do many other things with VLOOKUP.So in this article, we will show you ways of comparing two columns of data in excel using the VLOOKUP function in excel.
![]() Even there is any extra space or character; it cannot match the result. But the same VLOOKUP formula can match two columns data if we provide wildcard characters for the lookup value. This wildcard matches any number of characters for the provided value. It says CCD, and in cell A5, we have the full company name as Coffeeday Global Ltd (CCD). Because in the table array, we have the word CCD, wildcard matched this short form company name word with the entire company name in List B. ![]() So unless you are sure about the data you have, do not use this and rely on it. Copy Two Separate Columns In Excel How To Compare TwoHere we discuss how to compare two columns and find matches in excel using VLOOKUP and wildcard characters along with examples and a downloadable excel template. CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2021
Categories |