I have a list A with all my workflows and Forms. When I select “Site” in the current list, I want it to go to List 2 which has “Site” and “QA Manager” to lookup the value of Site and return the value associated with it. How do I accomplish that?

Table two:

A Manager | Site

Bob | Site 1

Cheryl | Site 2

When Site 2 is Selected in List one, it will return Cheryl to the QA Manager column on List one.

Thanks in advance