Excel - PonderBee

Home » Excel

Top 5 Reasons Why VLOOKUP is Not Working and How to Fix it Guaranteed

Posted on: 21st October 2019 | By: Sahil – 577 Comments

Working as a ‘Spreadsheet Guy’ i use VLOOKUP every day and a lot of people comes to me with an issue saying “my vlookup is not working”, for one reason or another. VLOOKUP is a very common excel function (in fact the 3rd most used …

What is Excel XLOOKUP Function and How to Use XLOOKUP?

Posted on: 5th September 2019 | By: Sahil – 337 Comments

In the last week of August, Microsoft announced a new function ‘XLOOKUP’ as an upcoming successor of famous functions such as VLOOKUP and HLOOKUP. Before I start to Explain what is XLOOKUP and How to use XLOOKUP Function, I want to tell you about VLOOKUP‘s incredible …