Trying to search specific name In this Sample.xlsx stored in SharePoint folder using Vlookup range
Name | Age | Department |
---|---|---|
John | 30 | HR |
Emily | 28 | IT |
Michael | 35 | Finance |
Jessica | 32 | Sales |
- Use Microsoft Office 365 Scope
- Find files and folders : Sample.xlsx in SharePoint folder.
- Use Vlookup Range activity. I have provided below inputs in Vlookup range activity inside Microsoft 365 scope but still getting below error.
Column index : 2
Exact match : True
Range : Empty Or “A2:C”
Sheet Name : Sample.xlsx
Value to lookup : Emily
Workbook : drive item (output of find files and folder)
Error : invalid argument
Argument is invalid or missing or has an incorrect format.