Pivot Table Assistance

Highlighted
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
Highlighted

@JesseHollett 

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

Highlighted

@Nikolino Got it, thank you!

Highlighted

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

Highlighted

Please share your excel file 

 

and also give more details to solve your issue

 

@JesseHollett 

Highlighted
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.

Nikolino
I know I don't know anything (Socrates)