Formula Trigger

Hello Experts,

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!

~ Geekamo
Who is Participating?
Shanan212Connect With a Mentor Commented:

Pull it down

Open in new window


^ Something like that?
GeekamoAuthor Commented:
@ oleggold,

When I put your formula in, it opens up a save dialog window?

@ Shanan212,

Your formula only returns "1" in the first cell.

@ all,

To elaborate a little further,...

If user types "5" into cell C14 on the Input worksheet, then I want a "1" in cell G6 of the List worksheet.  (The 5 in cell C14, it matching against the #'s in column C, then returning the "1" in column G.)

I hope that clears things up.

~ Geekamo
GeekamoAuthor Commented:
@ Shanan212,

Your formula worked great.  Although it got me thinking,...

Only after looking at your work, I could see what was happening and I created this,...


Which, it seems to work correctly.

I will be selecting yours as the answer, but I will be using the revised version in the actual workbook.

Thank you very much Shanan212!

~ Geekamo
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.