Fuzzy lookup in Excel

A brief tutorial on how to use Microsoft Excel Fuzzy Lookup a.k.a. Approximate Match in Excel. The Fuzzy Lookup Add-in matches inexact textual data, Identify near-duplicate rows within the single table and allows you to join data from multiple tables into one.

VLOOKUP() – Basics Part 2

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

VLOOKUP() – Basics Part 3

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

VLOOKUP() – Basics Part 4

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

MATCH() counts position number – Example 1

MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required. The value that you want to match in lookup_array. For example, when you look up someone’s number in a telephone book, you are using the person’s name as the lookup value, but the telephone number is the value you want. The lookup_value… Read More »

MATCH() counts position number – Example 2

MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required. The value that you want to match in lookup_array. For example, when you look up someone’s number in a telephone book, you are using the person’s name as the lookup value, but the telephone number is the value you want. The lookup_value… Read More »

VLOOKUP() – Basics Part 5

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

Using VLOOKUP with MATCH for 2d lookup Example 1

This technique is useful when you  have to look up a value in a table with both horizontal and vertical co-ordinates. We basically, select the table using VLOOKUP and select the relevant column using the MATCH function. This technique can be used which analyzing sales data,  logistics, employees data. We can alternatively use INDEX +… Read More »

Using VLOOKUP with MATCH for 2d lookup Example 2

This technique is useful when you  have to look up a value in a table with both horizontal and vertical co-ordinates. We basically, select the table using VLOOKUP and select the relevant column using the MATCH function. This technique can be used which analyzing sales data,  logistics, employees data. We can alternatively use INDEX +… Read More »

Debtors Ageing Analysis using VLOOKUP()

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

Score Grading using VLOOKUP()

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

Food Grading using VLOOKUP()

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

Using correct Service Tax rate using VLOOKUP()

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

Interworksheet VLOOKUP()

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

VLOOKUP vs HLOOKUP

VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) lookup_value (required) The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array .table_array (required) The range of cells in which the VLOOKUP will search for the lookup_value and the return value.… Read More »

ROUNDUP() & ROUNDDOWN() Basics 02 – Round off numbers

ROUNDUP:- The ROUNDUP function requires two arguments: The first argument is the number to be rounded. This can be a number that you specify directly in the formula, or a cell reference. The second argument is the number of decimal places to which you want to round the result. ROUNDDOWN:- The ROUNDDOWN function requires two… Read More »

Basics of 2 logical functions – AND(), OR()

AND Functions:- AND(logical1, [logical2], …) The AND function syntax has the following arguments: logical1 Required. The first condition that you want to test that can evaluate to either TRUE or FALSE. logical2, … Optional. Additional conditions that you want to test that can evaluate to either TRUE or FALSE, up to a maximum of 255… Read More »

SUMIF() Basics 01 – Adding numbers based on criteria

You use the SUMIF function to sum the values in a range that meet criteria that you specify. SUMIF(range, criteria, [sum_range]) The SUMIF function syntax has the following arguments: range Required. The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain… Read More »

AVERAGEIF() Basics 01 – Finding Average using criteria

Returns the average of all the cells in a range that meet a given criteria. The AVERAGEIF function syntax has the following arguments: Range:- Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers. Criteria:- Required. The criteria in the form of a number, expression, cell reference, or… Read More »

Calculating Year on Year Percentage Growth

Calculating  Percentage Calculating Year on Year % Growth in Excel in Hindi First: work out the difference (increase) between the two numbers you are comparing. Increase = New Number – Original Number Then: divide the increase by the original number and multiply the answer by 100. % increase = Increase ÷ Original Number × 100.… Read More »

Learn AutoSum function in Excel in Hindi

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on theHome tab, press Enter, and you’re done. For Windows users, you can also use “Alt” +”=” to use autosum.

Find Maximum value in Excel

Returns the largest value in a set of values. Syntax MAX(number1, [number2], …) The MAX function syntax has the following arguments: Number1, number2, … Number1 is required, subsequent numbers are optional. 1 to 255 numbers for which you want to find the maximum value.

AutoFill – Automatically write Dates, Months, Years

AutoFill – Automatically write Dates, Months, Years in Excel in Hindi Automatically repeat values that already exist in the column If the first few characters that you type in a cell match an existing entry in that column, Excel automatically enters the remaining characters for you. Excel automatically completes only those entries that contain text or… Read More »

how to Remove Drop Down list in Excel in Hindi

Remove Drop Down list Hello, everybody, today we are going to talk about how to Remove Drop Down List and we hope that you might be liking our tutorial and learning from it. Anyways, in this tutorial of Excel Superstar, we are going to answer a query. Our Excel experts received a many E-mails on… Read More »

How to store numbers as text in less than 2 mins (Excel in Hindi)

Store Numbers As Text In Excel In this tutorial, we are going to discuss an important trick of excel which is called as “Store Numbers As Text“. Many times we try to enter a cheque number for example 000876. As we move to another cell, the number which we entered will appear something like this… Read More »