Forum Discussion
ESTIMATORMJ
Aug 07, 2022Copper Contributor
IF A CONDITION IS TRUE THEN SPECIFIC TEXT IS INSERTED
I'm hung up here... What I'm wanting to do is— Context of the issue— Writing default subcontracts for all construction disciplines to be uploaded on the server and used by multiple users, some ...
- Aug 07, 2022
First save all terms and condition to a sheet against keyword will be selected from dropdown. Then use VLOOKUP() or INDEX/MATCH function to your desired sheet to show terms & condition based on selection of dropdown. We need more details to suggest you specific formula.
ESTIMATORMJ
Aug 08, 2022Copper Contributor
You saved me, my friend. I was way overcomplicating things. Index/match was the way to go. I appreciate you taking the time to sort it out for me. Have a good Monday. Harun24HR
Harun24HR
Aug 09, 2022Bronze Contributor
Glad to know. You can tick mark the answer.