hyperlink to my sheet: https://docs.google.com/spreadsheets/d/19R02b5CVaW_ndLb3Ag_pdmb-H_CHFVdt3zd89gplPRc/edit?usp=sharing
I am having hassle understanding what i am doing unsuitable. I would prefer to have this spreadsheet autofill knowledge based mostly on the choice from the drop down menu underneath title. Within the examples tab I would like to have the ability to choose a reputation from the drop down menu and have it mechanically fill of their cellphone numbers and emails based mostly on the knowledge plugged into the “Contacts” sheet.
from what I perceive this may be achieved with an array system, however I appear to be misunderstanding the appliance. that is the system I’ve gotten to to date, was questioning if somebody may define what I am doing unsuitable?
=arrayformula(IF($E4:E8=Contacts!D4:D8, hlookup(Contacts!G4:G16,F4:F16, 1, False)))