Find text and show value iif condition is met : Can someone help me a little bit. Picture is attached.
What I need is a code that will find "TOTAL PURCHASE" that has offset(-9)="USD" and then in cell D1 show the value of 100.



[1] https://imgur.com/a/oa0n0



