1.在這個公式中D2是您要返回其相對值的條件,A2:B10您使用的數據范圍,數字2指示返回匹配值的列。 2.如果要返回特定的文本而不是#N / A值,則可以應用以下公式:= IFERROR(VLOOKUP(D2,A2:B10,2,FALSE),“具體文字“)。 Vlookup通過強大的功能返回空白或特定值,而不是0或N / A 如果你有Excel的Kutools,其...
您是否遇到过在 Excel 中应用 VLOOKUP 函数时返回 #N/A 错误值或零的问题?在这里, Kutools for Excel 的 用空白或指定值替换 0 或 #N/A 实用程序可以帮助您通过在 Excel 中创建公式,用空或指定值替换零或 #N/A 错误。演示 将零或#N / A错误值替换为空 ...
We can use the empty string as a criterion to check if the value of the VLOOKUP is blank instead of using the ISBLANK Function: =IF(VLOOKUP(E3,B3:C7,2,FALSE)="","",VLOOKUP(E3,B3:C7,2,FALSE)) Note: Blank can be equivalent to zero or empty string depending on the calculation, but...
Please copy and paste the below formula into a blank cell (here, I select G2), and press Enter key to get the result: =VLOOKUP(F2,$A$2:$D$7,3,FALSE) Copy Note: In the above formula, there are four arguments: F2 is the cell that contains the value C1005 you want to lookup;...
Method 2 – Get Empty Cell Instead of #N/A Keep the cell empty when the searched name isn’t in your list, type the following formula in cellC13, =IFERROR(VLOOKUP(C13,B4:C11,2,FALSE), " ") C13= Lookup value which will be searched in the list ...
Formula to Return Blank Cell instead of Zero: Combination of IF and VLOOKUP Functions The following dataset contains some salespersons’ sales in two consecutive years. There are zero sales in some cells. We’ll use theIFandVLOOKUPfunctions in a formula to display blank cells in those cells in...
No Control tab of Format Control dialog in Excel 2010 No longer have share option under review tab Excel 2016 Not equal to in with vlookup Number Format "Yes";"Yes";"No" No Longer Works With TRUE/FALSE values Numlock turns off/on when macro is run ODBC Connection failed - error message...
=VLOOKUP(F2,$A$2:$D$9,4,FALSE) Now you will see if it's error in the original reference table, the Vlookup Function will return blank.Amazing! Using Efficient Tabs in Excel Like Chrome, Edge, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you ...
Tip.In Excel 365 and Excel 2021, you can use theXLOOKUP function, which is a more flexible and powerful successor of VLOOKUP. VLOOKUP syntax The syntax for the VLOOKUP function is as follows: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) ...
=VLOOKUP(10248, $A$1:$B$6, 2, FALSE) Instead of displaying #N/A error if you do not find a match, you could return the value "Not Found". To do this, you could modify your VLOOKUP formula as follows: =IF(ISNA(VLOOKUP(10248, $A$1:$B$6, 2, FALSE)), "Not Found", VLOOKUP...