How to Extract one column values based on other column in excel

Help Studio
1

Hi,

This is my input file

Momentofile

my output should be:
A=0,
B=2409.4
D=73867.4
H=0

this should be my output

please let me know how to get it.

Thanks in advance
Likitha

2

Hi @vinjam_likitha

we can achieve this using look up datatable

kindly refer the sample code
BlankProcess16.zip (41.5 KB)

Thanks,
Nikhil

3

Hi @nikhil.girish ,

I got the solution using Lookup data table what you have suggested.

Thank you very much for giving solution.

1 Like
4

Hi kindly close the topic @vinjam_likitha and mark as solution @vinjam_likitha

Happy learning

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.