सीधे मुख्य सामग्री पर जाएं

How to use Vlookup

You can trap #N/A errors and display a friendly message

In exact match mode, VLOOKUP will display the #N/A error when no match is found. In one way, this is useful because it tell you definitively that there is no match in the lookup table. However, #N/A errors aren't very fun to look at, so there are several ways you can trap this error and display something else instead.
Once you start using VLOOKUP, you're bound to run into the #N/A error, which occurs when VLOOKUP isn't able to find a match.
This is a useful error, because VLOOKUP is telling you clearly that it can't find the lookup value. In this example, "Latte" doesn't exist as a beverage in the table, so VLOOKUP throws an #N/A error
VLOOKUP sporting an #N/A error

टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

ROW Function

MS Excel:  How to use the ROW Function (WS) This Excel tutorial explains how to use the Excel  ROW function  with syntax and examples. Description The Microsoft Excel ROW function returns the row number of a cell reference. The ROW function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ROW function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the ROW function in Microsoft Excel is: ROW( [reference] ) Parameters or Arguments reference Optional. It is a reference to a cell or range of cells. Returns The ROW function returns a numeric value. Note If the reference parameter is omitted, it assumes that the  reference  is the cell address in which the ROW function has been entered in. For example, the ROW function used in the picture above returns 1 because the RO...
एक टिप्पणी भेजें
और पढ़ें