Dynamically serach string and the value in next cell

[hegdepavithra10]

Hi,

I have a excel file as below:

Is there a way to dynamically serach for the string and then the value next to it. For eg: Sum of PL's ,may not occur in the same cell always. How can i dynamically search for that string and the value next to it?

This is my desired output.

So far , i have selecting the columns using select and then using filter tool to segragate it. However my method would be static if the value moved cells.

[atcodedog05]

Yes should be possible @hegdepavithra10 

Basically you want to give field list and get field name & values should be possible.

I will do that for you.

But its suggestable if you give a different example data.

[atcodedog05]

Hi @hegdepavithra10 

The workflow would be something like this with highlighted being the reference field list.

Hope this helps 🙂