Hello,

I would like to know if there is a function which I could use to search a
column to find values which would equal a certain value.

For instance I have a list of:

1
2
8
98
65
45
25
98

I would like to search that column for any of those values which would add
to 123. The function would then return or highlight the 98 and 25 because
those add up to 123.

Is there a way I can do this?

Thanks for your help!