Lookup Issues

[Rock_boy]

G'day,
I'm trying to create a profit tracking sheet with a couple of tabs, the first tab records all sales and prices and item. the item code is created in this sheet using A1&B1&C1 to combine certain attributes that identify it, this same code is in my stock tracking sheet just as an example 1942d6dRAW is one. in the third sheet i calculate or am trying to the margins based on the sale price minus the cost price using the item code in a lookup formula. Currently trying to get the formula below to work but its not and don't have any other ideas why it's not working or other ways to do it.
=(Sold!D6)-(LOOKUP(Sold!H6,Cost!$C$6:$C$32,Cost!$E$6:$E$32))

Regards

Geoff

[boopathiraja]

Hi, Try

Please Login or Register  to view this content.

[FDibbins]

1st, you dont need the braces ()

2nd, try this...
=Sold!D6-VLOOKUP(Sold!H6,Cost!$C$6:$E$32,3,0)

[Rock_boy]

Yeah I tried both but when I use the VLookup function it just comes up with #N/A

[boopathiraja]

I think you need to index and multiple match, post a sample in excel file