I’ve seen this problem come up in a few posts, but have not seen the answer.

Its simple enough - and comes down to not quite understanding how to treat data that is a reference.

I cannot for the life of me make a formula for the button that is able to insert “Option 3” as a lookup into a new row in Table 2.

It should be easy to find option 3 using the “Add this row” column checkbox. Alas, it isn’t.

Everything I’ve come up with ends up inserting “Option 3” as text into the Option column in Table 2 instead of inserting it as a reference.

And this then breaks other bits of my workflow later on.

Can anyone suggest a formula that would work in this case - or am I going about things the wrong way?

Cheers! B.