Identify fields that sum to specific amount

[rossEY]

I need to know if it is possible to identify which fields equal a certain amount on a row by row basis. Say for example I had an amount of 30, I would need field C to be flagged from the table below.

Please see the before and after tables below for illustration.

Before:

A	B	C	D	E	F
10	20	30	40	50	60

After:

A	B	C	D	E	F	G (fields equal to 30)
10	20	30	40	50	60	C

If I could take this to the next level and have separate columns indicating if any 2 fields sum to a certain amount also that would be even better (i.e. with example above A and B would be highlighted as they sum to equal 30). Realise this is far more tricky though so I'll be happy with solution to first example.

Thanks for any help.

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[rossEY]

Thanks Ponraj, I think that's halfway there. I may need to refine my question however.

So my end goal is really the following:

Ref	Date	A	B	C	D	E	F	Amount to Match	Field Matched
123	01/01/2018	10	20	30	40	50	60	30	C
456	01/02/2018	10	15	20	25	30	35	15	B
789	01/03/2018	10	12	14	16	18	20	18	E
101112	01/04/2018	20	23	26	29	32	35	20	A

[ponraj · Accepted solution]

Here you go!

WorkflowResults

[rossEY]

Perfect, thanks!