Inserting different price list based on service type

**rtee** · 11-16-2012, 06:22 PM

The attached worksheet has a tab "Service Pkg" I'm trying to figure out how to auto insert corresponding price list (specified in "Svc Price" tab) based on service selected from drop-down menus - C1 "Service Pkg" tab?

**FDibbins** · 11-16-2012, 07:10 PM

On sheet service pkg C1, you have no drop-down. I think I can see what you are trying to do (based on serv type sheet), but you have no values there...do you intend to use the values on svc price?

If so, see if the attached is what you need?

**rtee** · 11-16-2012, 08:16 PM

Thanks! Is it possible to have a blank value/cell instead of "$0.00" for those cells that have no price?

**FDibbins** · 11-16-2012, 08:28 PM

They came up blank on my file, but maybe we have different settings. try using this instead...
=IF(INDEX('Svc Price'!$A$18:$H$50,MATCH('Service Pkg'!$K20,'Svc Price'!$A$18:$A$50,0),MATCH('Service Pkg'!$C$1,'Svc Price'!$A$18:$H$18,0))="","",INDEX('Svc Price'!$A$18:$H$50,MATCH('Service Pkg'!$K20,'Svc Price'!$A$18:$A$50,0),MATCH('Service Pkg'!$C$1,'Svc Price'!$A$18:$H$18,0)))

**punitsaxena** · 11-17-2012, 06:58 AM

Is it possible , if we can add the check boxes on the each price for selection, that will make the process easy b'coz which ever component is selected by check box sum will be for those many components.... Is it possible?
I have a sheet of 250 components with their price, i want make a sheet where i can select the items by check box and the result should come with the sum of the selected items .

**rtee** · 11-17-2012, 02:25 PM

Thank you very much! Your suggestion worked. Cheers, Rick

**FDibbins** · 11-17-2012, 02:55 PM

@ rtee glad to help, and thanks for the rep

@ punitsaxena...
Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.