Hi,
This sheet has a table of pricing with a description and a size. I want to make a quote sheet that will return the price of the correct item when the description and size are selected in a drop down menu. What series of functions would work best so I can continually update and add to these pricing sheet? Any thoughts?
Thanks
Justin
You didnt actually have any drop-downs, but try this in C2, copied down...
=IF(A2="","",INDEX('Price Tables'!$C$9:$K$32,MATCH('Quote Sheet'!$A2,'Price Tables'!$A$9:$A$32,0),MATCH('Quote Sheet'!$B2,'Price Tables'!$C$7:$K$7,0)),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks