Hi

I was wondering if there was a function or way to extract info from another worksheet (database style)

I have my product-parts price list in a worksheet, and I want to create my price list in another worksheet and extract the parts prices to add up for my total price

I looked at the DGET function but i could not make it work because i have something like this

Parts Price/Part
part a 15
part b 10
part c 8
.
.
.
part z 6

In my worksheet, i want to be able to extract the price for part c in one specific cel and then in the next one to extract the price for part z for example

PRICE PRODUCT
Parts
part c ???
part z ???
part v ????

I need to be able to extract this parts prices for a bunch of different products (different parts in each final product)

Is this at all possible?

Thank you for your help!