Hyperlink to my sheet: https://docs.google.com/spreadsheets/d/1E3gH661qnZDUvP48Ubg6epuHwpDH70gANE8wW968dYg/edit?usp=sharing
I am having hassle understanding what I am doing mistaken.
I might wish to have this spreadsheet autofill knowledge primarily based on the choice from the drop down menu underneath title. Within the examples tab I might like to have the ability to choose a reputation from the drop down menu and have it mechanically fill of their telephone numbers and emails primarily based on the knowledge plugged into the “Contacts” sheet.
From what I perceive this may be achieved with an array components, however I appear to be misunderstanding the appliance. That is the components I’ve gotten to thus far, was questioning if somebody might define what I am doing mistaken.
=arrayformula(IF($E4:E8=Contacts!D4:D8, hlookup(Contacts!G4:G16,F4:F16, 1, False)))