Excel more complex Vlookups

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?


Create a combined column like first concatenate column company and entity code and perform the lookup on the combined column


1 Like

Thanks, I think this fits the bill.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.