首页 \ 问答 \ Google电子表格使用VLOOK UP获得多个结果(Google spreadsheet Multiple result with VLOOK UP)

Google电子表格使用VLOOK UP获得多个结果(Google spreadsheet Multiple result with VLOOK UP)

 单独工作的VLOOKUP公式是  
=if(VLOOKUP(E2,DB!$C:$E,1,0)>0,"COMPLETED",)
=if(VLOOKUP(E2,DB!$F:$H,1,0)>0,"IN PROGRESS",)
 
 问题是在单个单元格中显示两个结果时，我想出的公式是  
C2=if(AND(VLOOKUP(E4,DB!$C:$E,1,0)>0),"COMPLETED",if(VLOOKUP(E4,DB!$F:$H,1,0)>0,"IN PROGRESS","UNDEFINED"))
 
 我已经使用VLOOKUP以外的正常条件测试了公式，它没有任何问题，不确定它有什么问题。  
Example : C10=if(AND(E10=1),"ONE",if(E10=2,"TWO","NO DATA"))
 
 任何帮助赞赏。 可能是它的简单但我在最后3个小时拉我的头发。  
 谢谢 ：） 
 / ----------------------- /  
 更新于03.05.2016  
 很抱歉我发布的评论是因为我是新手使用Stack overflow。  
 我只尝试过没有任何AND条件的IF语句，但结果仍然相同。 VLOOKUP未返回第二个值。  
 C15=IF(VLOOKUP(E15,DB!$F:$H,1,0)>0,"COMPLETED",if(VLOOKUP(E15,DB!$F:$H,1,0)>0,"IN PROGRESS","UNDEFINED")) 
 
 
  我期望在单元格C2（sheet1）中检查单元格E2中的值与列C：H（表2 / DB）。 如果它属于列C：C in（sheet2 / DB）那么C2（sheet1）中的值应显示为“Completed”否则如果值在F列中：F（sheet2 / DB）则在C2（sheet1）中应该显示显示“进行中”。  
 
 链接到我的电子表格链接 

The VLOOKUP formulas which works individually are 
=if(VLOOKUP(E2,DB!$C:$E,1,0)>0,"COMPLETED",)
=if(VLOOKUP(E2,DB!$F:$H,1,0)>0,"IN PROGRESS",)
 
The issue is while displaying both results in a single cell, the formula which I came up for this was  
C2=if(AND(VLOOKUP(E4,DB!$C:$E,1,0)>0),"COMPLETED",if(VLOOKUP(E4,DB!$F:$H,1,0)>0,"IN PROGRESS","UNDEFINED"))
 
I have tested the formula with normal conditions other than VLOOKUP and it works without any issues, not sure what's wrong with it. 
Example : C10=if(AND(E10=1),"ONE",if(E10=2,"TWO","NO DATA"))
 
Any help appreciated. May be its something simple but I am pulling my hair out for the last 3 hours. 
Thanks :)
 /-----------------------/ 
Updated 03.05.2016 
Sorry for the comments that I have posted as I am new at using Stack overflow. 
I have tried with only IF statements without any AND conditions, but the result is still same. The VLOOKUP is not returning the second value. 
 C15=IF(VLOOKUP(E15,DB!$F:$H,1,0)>0,"COMPLETED",if(VLOOKUP(E15,DB!$F:$H,1,0)>0,"IN PROGRESS","UNDEFINED")) 
 
 
 What I am expecting in cell C2 (sheet1) is check the values in cell E2 against the columns C:H ( Sheet 2/ DB). If it belongs to Column C:C in (sheet2/DB) then the value in C2 (sheet1) should display as "Completed" else if the value is in column F:F ( sheet2/DB) then in C2 (sheet1) should display "In Progress". 
 
Link to my spreadsheet link

原文：https://stackoverflow.com/questions/36975642

更新时间：2023-09-21 06:09

最满意答案

 如user3159253所述，子模块URL在域之后应该没有冒号。  
 SSH：//dev@example.com/var/git/themes/Repository_B 

As commented by user3159253 the submodule URL should be without colon after the domain. 
ssh://dev@example.com/var/git/themes/Repository_B

Google电子表格使用VLOOK UP获得多个结果(Google spreadsheet Multiple result with VLOOK UP)

最满意答案

相关问答

Git子模块和ssh访问(Git submodules and ssh access)[2022-04-06]

将子模块更新为最新的提交(Update a submodule to the latest commit)[2023-02-11]

Git子模块添加：“本地找到一个git目录”问题(Git submodule add: “a git directory is found locally” issue)[2023-06-13]

git子模块更新(Git submodule update)[2023-08-24]

将Git子模块更新为最新的原始提交(Update Git submodule to latest commit on origin)[2024-03-19]

通过ssh更新引用本地存储库的子模块(Update submodule referencing to a local repository via ssh)[2022-05-08]

Git子模块使用不同的ssh密钥？(Git submodule using a different ssh key?)[2022-01-22]

如何通过ssh跟踪Jenkins无法检出git子模块？(How to track down a Jenkins failure to checkout git submodule over ssh?)[2023-08-18]

无法更新子模块(unable to update submodule)[2023-09-17]

如何将git中的子模块更新为该外部存储库中的HEAD提交(How to update a submodule in git to the HEAD commit in that external repo)[2024-01-12]

相关文章

最新问答