Hi,
Can someone help me find out how to look up multiple values in a excel sheet.
It should find a specific value in column 3 and then return the value in column 2 from the same row in Excel.
When the value (in this case name) only appears once it seems pretty clear. I used the Find and replace cells in worksheet. And then read from excel using the found row and found column.
However when the name appears multiple times in the worksheet I got a problem.
Instead of the found rows and columns I get a datatable %Cells%.
Can someone help me on how I can use the data to find the matching rows in a loop for each name?
