Search in a specific column for a match in Excel and getting value 3 cells to the right.
Hi, I am trying to find the best way to compare two excel spreadsheets and getting value from one. Excel 1 have a value I need to look for in Excel 2 in column C, if there is a match I need to get the value from Excel 2 in the same row as the match 3 cells to the right and populated that to Excel 1. Any help is appreciated, thanks.
IKOR PX
AU
Here are few useful posts for excel integration
https://collaborate.pega.com/question/excel-cellcolumn-updates
https://collaborate.pega.com/discussion/pega-robotics-excel-how
https://collaborate.pega.com/question/how-set-cell-value-excel-given-row-and-column-index
Basically, you would define two connectors and loop over one worksheet with an embedded loop over the second worksheet column. Then if a match is found, you could copy the value from 3 cells to the right in the 2nd sheet. To know the bounds of the sheets, you could refer to the UsedRange property which gives you the column and row count.