IFERROR With VLOOKUP And LEN AND LENB FUNCTION

Combining the IFERROR Function Formula with Logical VLOOKUP Functions Formula

IFERROR Function With VLOOKUP Function Formula

Description : -

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR Function With VLOOKUP function to trap and handle errors in a formula

Below Following Values if Error : -

#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!

For Example
A B    C D
Description Value Description Value Lookup
Product #N/A    Product    0
Product Details #VALUE!    Sale5 0
Item    #REF! Sale 0
Sale #N/A Item    0
Sales #DIV/0!    Name 0
Name #NAME? Num 0
Num    #NUM! Null 0
Null    #NULL! Product No.    125
Product No. 125 Product Data        220
Product Data 220 Product Details    0

IFERROR With VLOOKUP Formula

=IFERROR(VLOOKUP(D:D,A:B,2,FALSE),"0")

Here the Below Screenshot

How to Use LEN and LENB Function Formula Using in Excel

LEN and LENB functions Formula in Excel

Describes the formula syntax and usage of the LEN and LENB functions Formula in Excel

Description : -

* LEN Count the number of characters in a text string

* LENB Count the number of bytes used to represent the characters in a text string.

For Example :

* LEN Function Count the number of characters in a text string = Total Character is 51

LEN Formula in Excel =LEN(A1)

* LENB Function Count the number of bytes used to represent the characters in a text string = Total Bytes is 80

LENB Formula is =LENB(A1)

Important : LENB Function counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LENB behaves the same as LEN, counting 1 byte per character

Discount Formula in Excel

Discount Formula in Excel To Discount Formula an original price minus 5 is the same as Calculate to 95 of that value so if you have the Product Price (4585) in A2 use the Discount Formula Here the Below Example for Discount Formulas : - 5% Discount formula is =A2*0.95 10% Discount formula is =A2*0.90 15% Discount formula is =A2*0.85 20% Discount formula is =A2*0.80 25% Discount formula is =A2*0.75 30% Discount formula is =A2*0.70 40% Discount formula is =A2*0.60 50% Discount formula is =A2*0.50 Another Way to Calculate Discount Formula in Excel How to Find Discounted Amount in Excel Column A is Product Price, Column B is Discount Percentage, Column C is Discounted Amount and Column D is After Discount Amount Discounted Amount Formula is =A2*5% After Discount Amount Formula is =A2-C2 Another Easiest Way to Calculate Discount F ormula Col umn A is Product Pr ice, Col umn B is Discou...

Excel Some Useful Shortcuts Excel Some Useful Shortcuts Shortcut key Action Menu equivalent comments Alt or F10 Menu Go to Menu bar Alt+’ Format Style dialog box Format the Style Alt+= AutoSum Sum Formaula Showing in Cell Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List Alt+F1 Insert Chart Insert the Chart Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor Alt+F2 Save As Save File to Save As Alt+F4 Exit File Exit Alt+F8 Macro dialog box Macro dialog box Tools Alt+Shift+F1 New worksheet Insert New Worksheet Alt+Shift+F2 Save Save the File Ctrl + Shift + L Filter Filter the Row Ctrl W Close Close the Open File Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection Ctrl+! Format cells dialog box Font Tab Open in F...

Basic Excel Simple formulas

Search This Blog