Oops... I can't read. Highest revision, not $$$.

=SUMPRODUCT(--(Sheet2!$A$2:$A$8=A2),--(Sheet2!$B$2:$B$8=MAX((Sheet2!$A$2:$A$8=A2)*Sheet2 !$B$2:$B$8)),Sheet2!$C$2:$C$8)

Scott

Scott wrote:
Try the following, entered with CTRL+SHIFT+ENTER:

=MAX((Sheet2!$A$2:$A$8=A2)*Sheet2!$C$2:$C$8)

Scott

Terri wrote:
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