Month: January 2020

Bye Bye VLOOKUP, Welcome XLOOKUP!

Yes, its true, It is time to forget Vlookup, Hlookup, Index-Match as Microsoft Excel is now fully loaded with XLOOKUP. This best in breed function is called XLOOKUP as it can do Cross lookup (*vertically as well as horizontally). Here is the quick syntax: =XLOOKUP (lookup_value, lookup_array, return_array, […]

We improve our products and advertising by using Microsoft Clarity to see how you use our website. By using our site, you agree that we and Microsoft can collect and use this data. Our privacy statement https://jayantkodwani.com/get-certified/privacy-policy/ has more details.