Please view attached file.
I am looking to place a formula in column G, of the List worksheet.
The formula, will need to do this...
Look at cell C14 on Input worksheet, if it contains a number then it needs to look in column C of the List worksheet for the correct row, and then return a "1".
If there is a "1" in column G, that changes the value of cell F24 on the Preview worksheet. The "1" is my trigger, and now I need the user to control where that trigger falls.
I hope that made sense.
Thank you in advance for your help!