USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
N / A #
|
|
|
DIV / 0 #
|
|
|
! REF #
|
|
|
VALUE #
|
Detailed explanation-1: -The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data. In this case there is no “Banana” listed in the lookup table, so VLOOKUP returns a #N/A error.
Detailed explanation-2: -Solution: Shorten the value, or use a combination of INDEX and MATCH functions as a workaround. This is an array formula. So either press ENTER (only if you have Microsoft 365) or CTRL+SHIFT+ENTER.
Detailed explanation-3: -Problem: The exact match is not found Solution: If you are sure the relevant data exists in your spreadsheet and VLOOKUP is not catching it, take time to verify that the referenced cells don’t have hidden spaces or non-printing characters. Also, ensure that the cells follow the correct data type.