Just need "yes" or "No" if someone hit quota.

[thespasticone]

So I think this is really easy, but I can't quite figure it out.
I have a book with multiple sheets.
(Using | below to show different columns) (cut out a lot of data points, but there is a lot more sales codes/quotas, and employees)
In one sheet I show the quota based on job title as such:
Sales Code |Quota
AM |$200.00
PT1 |$100.00
PT2 |$125.00

in another sheet i have individual sales people and performance, as such
Last Name |First Name |Classification |Sales |Quota Met?
Allbaugh |Joshua |AM |$4,000.00|

I just need the "quota met" column to reference the quota in sheet one, the performance in sheet two, and say "yes" or "no".

Help please!

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][td="bgcolor:#C0C0C0"]

E​

[/td][td="bgcolor:#C0C0C0"]

F​

[/td][td="bgcolor:#C0C0C0"]

G​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]Some other sheet[/td][td="bgcolor:#F3F3F3"]

Sales Code ​

[/td][td="bgcolor:#F3F3F3"]

Quota​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td][/td][td]AM [/td][td]

$200.00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td][/td][td]PT1 [/td][td]

$100.00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td][/td][td]PT2 [/td][td]

$125.00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]This sheet[/td][td="bgcolor:#F3F3F3"]

Last Name ​

[/td][td="bgcolor:#F3F3F3"]

First Name ​

[/td][td="bgcolor:#F3F3F3"]

Classification ​

[/td][td="bgcolor:#F3F3F3"]

Sales ​

[/td][td="bgcolor:#F3F3F3"]

Quota Met?​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td][/td][td]Allbaugh [/td][td]Joshua [/td][td]AM [/td][td]

$4,000.00​

[/td][td="bgcolor:#E5E5E5"]Yes[/td][td]F8: =IF(E8 >= VLOOKUP(D8, $B$2:$C$4, 2, 0), "Yes", "No")[/td][/tr]
[/table]