I have Excel table where are two columns:
RPA reads with OCR from PDF document vendor ID number.
I need to get vendor name from second column(VendorName) in a row where VendorID matches to vendor ID what was in PDF document.
I think i need to do following steps:
- Add Excel table to table variable with GetRange
- Do for each loop with table variable for rows
- Add second nested for each loop for looping row columns, filtered to VendorID column
Question is: How i get vendor name to variable if second for each loop is filtered to VendorID column?
Or is it possible to add reference to table column somehow, so the table don’t need to filtered?