How to pull text from column B if cell matches data in column A

[Closed]
Report
-
I want my form to know which employee is assigned to the county listed on the form. Basically, if cell F5 says Multnomah, I want the formula to look at the County Assignments tab and find Multnomah County and pull the employee listed next to it into cell K7 in the original tab. Is that possible?