I’ve been watching the UiPath academy videos on Excel manipulation and Youtube, and can’t quite work out how to do what I need to do here with the Modern Excel activities like Vlookup.
I have 2 excel workbooks, one a set of actual values containing company names, entity names, the second Excel has a set of Company names, Entity names and Project codes.
I need to lookup in the second sheet where the company AND the entity code columns are the same as in the values sheet and then fill in the project code from that row. I’m not sure how to do this as Vlookup seems to only compare 1 column, but I need it to compare 2.
Does anybody know how to do this?