Replacing Cell content based on intersection of Rows and Columns with specific values

Hello,
Can anyone suggest how I can select a cell based on row and column header values and replace that cell content?
In other words, pseudo-code would be something like:
Find all rows in Column A with value ("Cash" or "Totals for Cash")
Now find all columns in Row 1 with title ("RoofType" or "Mountain") intersecting with rows found above and put in a value "TODELETE"

I've uploaded a sample sheet that has the example worked out. Thank you very much!1.xlsx

You have a typo in your header "Mountainious" ?

Please Login or Register  to view this content.