How to find out excel one column value to another column value and copy & paste that find value to next new column

In row(A1) value is emp id–“abc123” to find row(E) – have multiple emp id , i need to find A1 value and than get same row(F)–salary

I attached screen shot for yours ref,

kindly help me

Hi @Raja.G,

Use read cell to read the A1 Cell’s data.


And use read Read Range Activity from E1 and do the filters :slightly_smiling_face: