Forum Discussion
Conditional Formula, based on a value, that then looks for cells part containing a defined value
FelixScatt Best to upload an example file, as it becomes a bit abstract imagining how your real schedule looks like. Make sure you remove any private and confidential information.
Thanks for the advice Riny_van_Eekelen. I'll try again, with context...
Cell C3 contains a Data Validation list.
Cell C4 contains a Data Validation list which is dependent on the value in C3.
As the image provided shows, C4 has 3 Branch options: Cust1 Head Office, Cust1 S1, and Cust1 S2.
If Cell C4 contains a value, then Cells H3:H6 are populated based on the conditional value.
Aim:
What I am trying to achieve is for H3:H6 to default to the value that contains "Head Office" if Cell C4 is blank. It needs to lookup the range of values to find the cell that contains "Head Office" as part of its value, which will then return the values into the H Cells.
@Riny_van_Eekelen. Working example attached.
FelixScatt See if the attached is acceptable for you. Column L:M on the main sheet, that is.
Riny_van_Eekelen That looks spot on! Thank you so much. Much appreciated.
FelixScatt Better to upload the file with some example data in it. Not just a screenshot.