Heather Cott
unread,Jan 7, 2022, 5:41:56 PM1/7/22You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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))))))))))))