8 Ocak 2022 Cumartesi tarihinde saat 00:41:56 UTC+2 itibarıyla Heather Cott şunları yazdı:
Hello,
I know there are a lot of these questions but my formulas seem to be a bit different and I am not sure where to add the "false" part of it.
I have drop-down menus where I chose something and it populates that services company name and phone number so on the cells where I don't have anything picked on the drop-down, it just says "False" and I need that gone. I am completely out of ideas.
Thank you for your help and expertise!
Here is my condition:
=IF(B42="Cable",QUERY(CompanyInfo,"SELECT B WHERE A='Cable'"),IF(B42="Septic",QUERY(CompanyInfo,"SELECT B WHERE A='Septic'"),IF(B42="WIFI",QUERY(CompanyInfo,"SELECT B WHERE A='WIFI'"),IF(B42="HVAC",QUERY(CompanyInfo,"SELECT B WHERE A='HVAC'"),IF(B42="
Pool Service",QUERY(CompanyInfo,"SELECT B WHERE A='Pool Service'"),IF(B42="Propane",QUERY(CompanyInfo,"SELECT B WHERE A='Propane'"),IF(B42="Pump/Well",QUERY(CompanyInfo,"SELECT B WHERE A='Pump/Well'"),IF(B42="Trash",QUERY(CompanyInfo,"SELECT B WHERE A='
Trash'"),IF(B42="Recology",QUERY(CompanyInfo,"SELECT B WHERE A='Recology'"),IF(A8="purple",5,IF(A8="yellow",6,IF(A8="green",7))))))))))))
Adana masaj
https://masaj.sevcez.com/Masaj/Adana-Masaj ilanları
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)