Linq query with the found element

[ppr (Peter Preuss)]

@maroua301

we learned from Santa /& Rudolf:

Advent #8

Sure we respect every confidental needs. But sample data can be created even without breaking confidental needs:
Type_SERVICE | Col2 | Col1
###Corporate | 12|A3
###OtherText …
…

Have a look here:

Compare two excels and update

Hi all, I am currently trying to make comparison between two excel files. I need to match the value of User ID (Excel 2) with User ID (Excel 1). If value match, I have to write “Open” on column Status (Excel 1). Then if we found a match from first condition, everything from the same group of that user ID also I have to write “Open”. Example: I found a match for User ID = 18. User ID 18 is on Group A. So I have to write status “Open” to User ID = 1 & User ID = 23 since they are from Group A. …

it is a very good example on how visually and with abstract sample data the case was explained

Some sample data would really help. The mentioned above description / XAML is not razor sharp defining all requirements. (Does First mean first row, first occurence … all important requirements)

So please help us with some more details that we can work out a better fitting solution approach.

Many thanks for your support
Kind regards
Peter