Pivot Table Assistance

New Contributor

Hello there Experts!


I have a *I believe* a pivot table question. I'm looking to create a table that generates a cost when answering five questions. Each question would have to be linked to a data sheet that has the data to pull from. My question is: When generating this program in excel, which formulas would I have to use to do that, and how would I use them? Please refer to the options below. I'd like it to be a table that I can select options from or type in a response and it associates the response to the data on the additional data sheets. 

5 Replies


* Beware of scammers posting fake support and phone numbers here.

@Nikolino Got it, thank you!

Guys, I don't really care about who is a fraud and who isn't... I just want some help with this formula...

Please share your excel file 


and also give more details to solve your issue



It's not what you are, it's what and where you ask.
Here is a forum for Excel users who trust the site as Microsoft and not your name. You advertise on Microsoft Internet sites without even asking whether it is allowed at all or whether it could have legal consequences. No matter where you are in the world.
The rules of use clearly state that no advertising or any kind of business is allowed here.

* Beware of scammers posting fake support numbers here.

I know I don't know anything (Socrates)