Link to my sheet: https://docs.google.com/spreadsheets/d/1E3gH661qnZDUvP48Ubg6epuHwpDH70gANE8wW968dYg/edit?usp=sharing

I'm having trouble understanding what I'm doing wrong.
I'd like to have this spreadsheet autofill data based on the selection from the drop down menu under name. In the examples tab I'd like to be able to select a name from the drop down menu and have it automatically fill in their phone numbers and emails based on the information plugged into the "Contacts" sheet.

From what I understand this can be achieved with an array formula, but I seem to be misunderstanding the application. This is the formula I've gotten to so far, was wondering if someone could outline what I'm doing wrong.

=arrayformula(IF($E4:E8=Contacts!D4:D8, hlookup(Contacts!G4:G16,F4:F16, 1, False)))

  • Welcome. Please share the spreadsheet with anyone with the link is allowed to view. Commented Apr 23, 2020 at 21:55
  • updated, my apologies
    – JTilman
    Commented Apr 24, 2020 at 0:45
  • Have you tried the given solution? Did it work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it and maybe upvote it so others can benefit as well. Commented Apr 24, 2020 at 18:42

1 Answer 1


Please use the following formula for your needs:

=IFERROR(ArrayFormula(VLOOKUP(E4:E16,Contacts!$D$4:$H$16, {4,5}, False)))

Functions used:

  • This did it, thank you!
    – JTilman
    Commented Apr 24, 2020 at 22:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.