lookup function .... I think???

[cameronfunk]

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

 

[RichardSchollar]

Hi Cameron

How about something like this:

=VLOOKUP(Sheet1!A2,Sheet2!$A$2:$D$1000,MATCH(Sheet1!B2,Sheet2!$B$1:$D$1,0),0)

Ranges will need adjusting to suit.

Best regards

Richard

 

[cameronfunk]

Had some problems with the text but all worked out in the end. I knew it
would work and you proved me right. Thanks so much.