Google表格VLOOKUP从一行/单元格多次显示 [英] Google Sheets VLOOKUP multiple times from one row/cell

问题描述

我正尝试使用Google表单为家长填写注册表单。家长有能力以一种形式注册多个孩子。为了更容易阅读，我使用了以下内容：

  = sort（unique（{A2：B999; C2： D999}））
  

现在我想从提交中提取紧急联系信息，但由于某种原因， VLOOKUP只能为第一个孩子提供服务

以下是简化的回复表：

I am trying to create a sign up sheet using Google Forms for parents to fill out. Parents have the ability to sign up multiple children in one form. For it to be easier to read I have organized the entries using:

=sort(unique({A2:B999;C2:D999}))

Now I want to pull the emergency contact information from the submission but for some reason my VLOOKUP can only pull it up for the first child

Here is the simplified response sheet here : goo.gl/soE1PG

解决方案

Pass the lookup off to a second VLOOKUP function with IFERROR function if the first fails.

In I5 as,

=IFERROR(VLOOKUP(G5, A:E, 5, FALSE), VLOOKUP(G5, C:E, 3, FALSE))

Fill down as necessary.

    

这篇关于Google表格VLOOKUP从一行/单元格多次显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！