I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)