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.
in Below suppose A column value is 305 then AM should get from B column.
I have used below activity which gives me reference as A7, So want to get value from B7