Filter vlookup based on parent person field

[Christopher Holubarz]

Hi,

I have following task to fulfill:

I habe a list which contains a person field. The vlookup is targeting a task list and I want to filter on tasks that only have the person field value from the parent list in the assignedto field.
How can I achieve this ?`

Thank you very much in advance.

For info: I am using DFFS and vLookup.

BR,
Chris

[Alexander Bautz]

Hi,
Try setting up the “query” in vLookup like the attached image. Change “AssignedTo” and “PeoplePicker1” with your field names.

Alexander

Attachments:

1. 

   vLookup_filter_on_pp.png
   

[Author]

Posts