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.
    – Rubén
    Apr 23, 2020 at 21:55
  • updated, my apologies
    – JTilman
    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. 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
    Apr 24, 2020 at 22:43

Your Answer

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

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