Hello, this is what I have.

sheet 1
ID(A) Item #(B)
CAFRLT G804170619
CAFRLT G805170652
CAFRLT G812170652
CANGEO G804170619
CANGEO G805170652
CANGEO G812170652

sheet 2
ID(A) G804170619 (B) G805170652(C)
G812170652(D)

CAFRLT $1,057.26 $949.50 $114.40
ALFPET $0.00 $0.00 $0.00
CAWERE $0.00 $0.00 $0.00
CANGEO $265.30 $211.50 $27.20
CARAVE $435.10 $557.10 $30.40

what I need is a formula in sheet 1 that will go and look for the ID
and the Item Code and give a corresponding value. I can't make it work
to save my life. Any help would be greatly appreciated. Thanks


--
cameronfunk
------------------------------------------------------------------------
cameronfunk's Profile: http://www.excelforum.com/member.php...o&userid=34569
View this thread: http://www.excelforum.com/showthread...hreadid=547135