VLOOKUP MATCH – Solution for VLOOKUP REF Error The article “VLOOKUP REF Error – Causes and Solutions” explains the possibility of a REF error, or there is no REF error, but the resulting data is incorrect. The following article explains how to prevent these two problems. …

There is a condition, you have written the VLOOKUP function correctly but still returns an NA error, occurs when lookup_value does not exist in the first column of table_array. No problem, no lookup_value in the price table, but the total bill must show the bill for …

The Wrong Cell Reference The wrong cell reference is the most common error when using the VLOOKUP function to look up for multiple data at once. For example, there is data like the picture below, how much you have to pay for all tall orders? To …

VLOOKUP REF Error because one or more table_array column is deleted Deleting table_array column causes VLOOKUP REF error when the col_index_num value becomes greater than the number of columns in table_array. This error occurs when VLOOKUP formula has already written; then someone deletes one or more …

Pay attention to the data below. A store sells five products. The beginning stock of each product is 100 pcs. At the end of the month, the clerk calculates the end stock of each product (see column C) and the money earned for each product (see …

How to divide in Excel? For example, there is data like the picture below, ten numbers in the range A1:A10 will be divided by ten numbers in the range B1:B10. How to create a division formula in Excel? Solution Using Using Slash “/” Sign To create …

For example, there is data like the picture below, four numbers stored in different columns. What is the formula for multiplying these four numbers? Multiplication Formula Using the Asterisk “*” Sign The multiplication formula in Excel uses an asterisk “*” sign, different from the sign used …

The date and time value can be written in one cell but can be separated. There are several ways to separate them. For example, there are date and time values as shown below with various formats. How to separate date and time in excel? Using INT …

Excel stores TIME values in decimal numbers, but in day unit. The first way to convert a time value to hours, minutes or seconds number is to use the multiplication formula. The second way is using the excel CONVERT function, an excel function to convert from …