# Formula Trigger

Hello Experts,

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.

~ Geekamo
Pallet-Tag-Generator--Must-Enabl.xlsm
LVL 1
###### Who is Participating?

Commented:
=IF(ISNUMBER(Input!\$C\$14),IF(Input!\$C\$14=C2,1,0),0)

Pull it down
0

Commented:
try:
``````=IF(ISERROR(SEARCH("INTEGER",(VLOOKUP(C29,ALL_TABS!C:J,4,FALSE)))),0,I29)
``````
0

Commented:
=IF(ISNUMBER(Input!C14),1,0)

^ Something like that?
0

Author 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
0

Author 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,...

=IF(C51=PrintSelection,1,"")

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
0
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.