VLOOKUP multiple times from one row/cell

Question

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: [goo.gl/soE1PG]

Answer 1

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.