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 …
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 …
Working as Employee in an Office to being a computer geek, we always try to find out new keyboard shortcuts. We have to admit, using shortcuts keys (HotKeys) looks more professional and cool, also it gives you that edge over other users. Today I will …