Please help with formula
In the WO$ cell on worksheet 1, I need it to look on worksheet 2, match the
project number, find the highest revision and return the $$$ amount.
Worksheet 2 is not sorted in any specific way.

WS1

Project Description WO$
1 Test 1
2 Test 2
3 Test 3

WS2

Project Revision $$$
1 1 1,000
2 1 2,000
3 1 2,000
2 2 5,000
2 3 10,000
1 2 6,000
3 2 8,000

WS1 Result would be

Project Description WO$
1 Test 1 6,000
2 Test 2 10,000
3 Test 3 8,000