vlookup two nested conditions

[Ana Quevedo]

I have a situation where I need to do a nested “And” vlook up. However, the second field I’m calling is “hard coded”. Rather than setting a field as a criteria, I’m setting the value.
Ex:
Parent:
Title = “Text of field”
Framework2015 = “Yes” or “No” (choice drop down)
Child:
Title = “Text of field”
2015Framework = “Yes” or “No” (choice drop down)
Objective:
I need the child list to go to the parent list and find the matching record by using the title field (this I can do). I then need a nested “And” condition where it only renders back the fields where the 2015Framework = Yes in the parent list (there are items set to no). This is where I’m having difficulty.

Attachments:

1. dffs-vlookup-troubleshoot-Mar-2015.doc

[Ana Quevedo]

I figured out the problem. Please disregard.

[Author]

Posts