I need formula Help!
I am trying to find a formula that will allow me to Reference another sheet and look in two columns (One is a multi select drop down, and one is a text column) and find the row that contains both of those values and return a third column (Contact) from the referenced sheet.
So Sheet A is where I want the formula to return the contact, and Sheet A also have a Property Name Column.
I want the formula to find a property name in a column in sheet B that matches the Property Name in the row with the formula, but since there will be multiple rows in Sheet B with that property name it also needs to match a Title that I can either add to sheet A or type into the formula.
If both the Property Name and Title Columns match in the same row in Sheet B return the contact from that row in sheet b.
I hope that makes sense. I am not sure how else I can show you these sheets to make it make sense. Any ideas on this?
Help Article Resources
Check out the Formula Handbook template!