i am trying to retrieve excel cell value and match into anther excel file column.if present then 1st scenario run. if not present then goes on 2nd scenario.
Hey, can you give a bit more information.maybe share excel file and tell is a bit more, this is pretty simple if its for each row… what cell?
So here is what I did, hope it helps.
Read range of Demo Excel and then for each row compare I1 cell, If - > then
I supouse that excel excel1 will change, so you need to find a way how to make value of file location to be variable, you can read all files from directory and then change with each run, or something like that.
RadomirForum-Excel.zip (35.4 KB)