Find X value from A,B,C,... columns

[Parth5]

I have excel file from where I want to find XYZ value where as XYZ value is coming in multiple columns. So in the output I want to see XYZ value only and from which columns it is coming from?

[Emil_Kos]

Hi @Parth5,

I have created a workflow for you:

Output:

[Parth5]

Thank you very much! that is what I want

[Parth5]

I got the correct column now in output. If I want to get correct value from the another table i.e. table B. Where I should get US/UK from the company name which is at 4th position after delimiter underscore. So, when it is Unclassified then it should get the data from table B.