New to VLOOKUP and/or FIND formulas

[Home Concepts]

Good Day All. I'm trying to develop a form for a small business that will take items from an inventory and place them on a form for materials costs for particular jobs. I would like to use drop down lists to select the individual items used on the job, and I want the price of said item to be reflected on the form. I've attached the begin of the form I would like to use, but because I'm fairly new to excel I'm not sure what formulas to try and even learn. Any help would be greatly appreciated. Thank you in advance for viewing my post, and many thanks if you're able to help me out.

Cheers.

[protonLeah]

Cost =

Please Login or Register  to view this content.

[Home Concepts]

Thanks for the reply Mr. Johnson, I feel slightly sheepish asking this, but in which cell do I apply this formula? In the product cell? or the price cell. When I placed in the product cell I got an error, I assume thats because I have a drop down list in the cell. When I tried it in the price cell it came up with a price of zero. I know I'm not doing something correctly but I don't know what. Any more help available?

Cheers.

[protonLeah]

I modified the formula:

Please Login or Register  to view this content.

goes in F2 to F38. I modified it to return blank when there is no description entered.

[Home Concepts]

Works beautifully. When I add more items, can i simply extend the range?

[protonLeah]

I modified the range names to make them dynamic, so they will adjust with changes in the PRODUCT list and the Quantity list

PriceList ---> =OFFSET(Products!$A$1,5,0,COUNTA(Products!$A:$A)-1,2)
Quantity ----> =OFFSET(Products!$A$1,5,0,COUNTA(Products!$A:$A)-1,1)

So, the cost formula in column F is changed to: =IF(B11<>"",VLOOKUP(B11,PriceList,2,FALSE)*A11,0)

[Home Concepts]

ProtonLeah you're the best! Works great!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.