我需要一些关于文档的谷歌电子表格的帮助。我想看看外部文档中的某个单元格中是否有(任何(值，但我想在更大的范围内进行，例如在 11 个不同的单元格中。
我有它，所以它会粘贴至少一个(包含所有代码(，但我需要它在一个单元格上运行所有这些代码。到目前为止，我的代码是：
=IF(ISBLANK(Attendance!$C10:$M$10), "GR",
IF(ISBLANK(Attendance!$D$10:$M$10), "MG",
IF(ISBLANK(Attendance!$E$10:$M$10), "PM",
IF(ISBLANK(Attendance!$F$10:$M$10), "GD",
IF(ISBLANK(Attendance!$G$10:$M$10), "MK",
IF(ISBLANK(Attendance!$H$10:$M$10), "CE",
IF(ISBLANK(Attendance!$I$10:$M$10), "PI",
IF(ISBLANK(Attendance!$K$10:$M$10), "SL",
IF(ISBLANK(Attendance!$L$10:$M$10), "BC",
IF(ISBLANK(Attendance!$M$10), "IN"))))))))))
似乎发现以下内容是合适的：
=if(isblank(C10)," GR","")&if(isblank(D10)," MG","")&if(isblank(E10)," PM","")&if(isblank(F10)," GD","")&if(isblank(G10)," MK","")&if(isblank(H10)," CE","")&if(isblank(I10)," PI","")&if(isblank(J10)," aa","")&if(isblank(K10)," SL","")&if(isblank(L10)," BC","")&if(isblank(M10)," IN","")
此公式是否如您所愿：
=VLOOKUP(COUNTA(C10:M10),{1,"GR";2,"MG";3,"PM";4,"GD";5,"MK";6,"CE";7,"PI";8,"SL";9,"BC";10,"IN";11,""},2,0)
如果没有，请分享一些示例数据和预期结果