从一行/单元格多次VLOOKUP [英] VLOOKUP multiple times from one row/cell

问题描述

我正在尝试使用Google表单创建一个注册表格，以供家长填写.父母可以用一种形式签约多个孩子.为了更容易阅读，我使用以下项组织了条目:

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}))

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

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.

这是简化的响应表:[goo.gl/soE1PG]

推荐答案

将查询传递给第二个

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

在I5中，

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

根据需要填写.

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