My last post was not so clear, as the formats were removed.

What I am trying to do is:

Write an event procedure, upon entering a "1" in a field, this matches the
column header against a corresponding set of data all on one row, and for
every match returns a formula on the same row as the 1 entered in the column
the match happened.
My Match headers are A,B,C, etc.
I hope this is clearer.
Many thanks for your help.
Paul