我有一个带有数据值的数据表（a），第二个表（b）是将这些条目分类为类别的键。
我正在尝试编写一个单元格公式，该公式将列出与（a）中数据值相对应的类别。
数据表中的某些条目是空的，即没有输入数据。
例子：
A13有一个空细胞，根据表（b），我特别希望将空白单元格归类为“其他”。目前，表格认为这样的单元格是“ null”而不是“空白”，因此返回＃n/a。
我尝试添加ifError函数，该功能在此阶段工作，但不适合该场景输入新的数据输入是最初也将显示为“其他”，因此我想避免使用：
=IFERROR(INDEX(D2:D13,MATCH(A2:A13,E2:E13,0)),"Other")
Col B的当前单元格公式：
=INDEX(D2:D13,MATCH(A2:A13,E2:E13,0))
请您提供帮助吗？我发现了很多有关如何忽略空白/空细胞的文章，但却没有包含它们。
非常感谢！
哦，
https://docs.google.com/spreadsheets/d/1a6atpbmmenaq7py8-pt3dhbbyx9unaioq-h1ts4iqmw/edit?usp = sharing？
问题的屏幕截图
I have one table of data (A) with data values, and a second table (B) which serves as a key that categorises/groups those entries into categories.
I am trying to write a cell formula that will list the category that corresponds to the data value in (A).
Some of the entries in the data table are empty, i.e. have no input data.
Case in point:
A13 has an empty cell, according to table (B), I specifically want the blank cell to be categorised as "Other". At the moment the sheet thinks cells like these are "null" and not "blank" and therefore returns #N/A.
I have tried adding an IFERROR function, which works at this stage but does not suit the scenario where a new data entry is entered as that will initially show as "Other" too when it should be something else, so I want to avoid using:
=IFERROR(INDEX(D2:D13,MATCH(A2:A13,E2:E13,0)),"Other")
Current cell formula for col B:
=INDEX(D2:D13,MATCH(A2:A13,E2:E13,0))
Please can you help? I've found plenty of articles on how to ignore blank/empty cells, but nothing to include them.
Many thanks!
OH
Shared link of problem
Screenshot of problem
发布评论
评论（1）
使用IFNA喜欢：
更新：
use ifna like:
update: