How to get next column value based on current column value

Help Studio
1

Hello,

I have excel file with A and B column data. I want to get “B” column value based on the “A” Column value.
I have user lookup range to find cell reference for A column as per value and get the correct reference also, but not able to get B column value.
Please suggest feasibility.

Ex.
in Below suppose A column value is 305 then AM should get from B column.

image

I have used below activity which gives me reference as A7, So want to get value from B7
image

2

Hey,
you can use Lookup dataTable activity
follow this screenshot
image
where outDT is output of Read Range activity of reading Input Excel File.
through Input Method you can give input-ouput of Input dialog box is -InputVar
Thanks

3

please follow below video

4

str=“305”
Str2=DT.Asenumerable.where(Function(r) r(0).Tostring.Trim=str).First().item(1).Tostring