Dynamically serach string and the value in next cell

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.

Data Investigation

Accepted answers

All comments

atcodedog05

Hi @hegdepavithra10

Can you provide the data as a sample file.

messi007

@hegdepavithra10,

Please see below:

Hope that helps!

Regards,

SumChecks.yxmd

hegdepavithra10

Hi @atcodedog05

Here is the sample data. I want to search for the string and the extract the cell next to it. And the output must be in the same format irrespective of where the data may reside. for eg : on the file you will see "Sum PL's" and the data is in A4 and B4, there is a chance that when i use a different file its location may be in E4 and F4. Hence i am looking for how they can be extracted and then placed in the same format mentioned in the out put section:1. Sum of PL's 2.Leaves so on and so forth. There are multiple files with the same data that i have to put under one file.

I hope the requirement is clear.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703