In the world of Microsoft Excel, if there’s one function that stands out as the go-to tool for data lookup, it’s the VLOOKUP function. Mastering Excel’s VLOOKUP function is like having a superpower that lets you quickly find and retrieve …
Lesson#250: Excel VLOOKUP Functions: Finding Data Matches Read more »
Creating charts in Excel is a powerful way to visualize data and communicate insights effectively. However, working with Excel charts can sometimes be frustrating, especially when you encounter issues related to data source problems. In this expert-level guide, we’ll delve …
Lesson#225: Fixing Excel Chart Data Source Problems: An Expert Guide Read more »
In this post, I am going to discuss on INDEX – MATCH combination. How can we make an efficient lookup function combining these two functions? I shall also discuss the comparison of INDEX – MATCH with VLOOKUP. What is the …
Lesson#160: How to use INDEX and MATCH? | INDEX-MATCH vs VLOOKUP Read more »
Hello Reader! Welcome to my other post on Excelabcd. Microsoft Excel has introduced a new function on Excel 365 and Excel online version. Which is the Excel XLOOKUP function. Which is the DAD of all LOOKUP functions. Here we shall …
Lesson#156: XLOOKUP vs VLOOKUP in Excel. Which one is better? Read more »
Okay, friends here I will show you some interesting tricks about Excel. That is how to VLOOKUP pictures in excel. We have learned to look up values from a table but looking up a picture from the table is a …
When you want to get the smallest or the largest number from an array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two …
Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more »
Here I have to make a parent Gantt chart from a data table. It is a Gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value …
Lesson#49: Make a parent Gantt chart from a data table Read more »
The INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Syntax of this function is INDEX(array, row_num, [column_num]) The array is required, If the array contains only one …