Programming

Ask a Programming Question, Get an Answer ASAP!

Have your own Programming question?

Programmers are Online Now

characters left:

Not a Programming Question?

Question

My question is for John D,

John, I made some changes to the spreadsheet you helped me with, and I need you to adjust the formula. I tried but it didn't work.

I've uploaded the file to: http://www.fileqube.com/file/aZmFGAXMO206683 As you'll see I made a more concise matrix of the different prices - but now I can't get the menu to refer to those new prices.

I understand that you'll need to charge me for this change - that's fine.

Thanks for your help,

Jacob

Submitted: 122 days and 16 hours ago.

Category: Programming

Value: $22

Status: AWAITING CUSTOMER ACTION

Posted by John D 122 days and 15 hours ago.

Info Request

Hi Jacob.

After reviewing this spreadsheet it looks like the source data structure has changed thus requiring adjustment in the formulas and setting up new formulas for column E. So if I understand the requirement correctly, if "4 groupss" is selected in B9, and "5 IDIs" is selected in D9, you want cell C9 to pull the amount 26500 from the table, and cell E9 to pull the amount 9500 from the table.

Unless I hear from you otherwise I will go ahead and make these changes. Will get back to you as soon as I am done.

122 days and 14 hours ago.

Reply

That is exactly right. Thank you.

When I re-arranged the data into the table I lost the association between the category names and the costs.

Thanks for the help,

B

Accepted Answer

Ok, here you go.

http://www.fileqube.com/file/unPFNJSHy206697

Hope this helps. Let me know if it needs any adjustments.

Edited by John D on 7/22/2009 at 9:55 PM

Accepts:
Expert:	John D
Pos. Feedback:	99.7 %
Answered:	7/22/2009

BS Degree in Engineering

20 years experience in Excel programming and various major applications.

Posted by John D 122 days and 8 hours ago.

Info Request

Was it ok? Did you need anything else?

122 days and 5 hours ago.

Reply

John,

That worked great. Thank you.

But I can't seem to find the accept button to pay you.

JB

Posted by John D 121 days and 21 hours ago.

Answer

Since you have already accepted I presume you were able to find the accept button and that there is no more problem in that regard.

Thanks and I look forward to assisting you again.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Programming

Have your own Programming question?

Question

Info Request

Reply

That is exactly right. Thank you. When I re-arranged the data into the table I lost the association between the category names and the costs. Thanks for the help, B

Accepted Answer

Ok, here you go. http://www.fileqube.com/file/unPFNJSHy206697 Hope this helps. Let me know if it needs any adjustments. Edited by John D on 7/22/2009 at 9:55 PM

Info Request

Was it ok? Did you need anything else?

Reply

John, That worked great. Thank you. But I can't seem to find the accept button to pay you. JB

Answer

Since you have already accepted I presume you were able to find the accept button and that there is no more problem in that regard. Thanks and I look forward to assisting you again.

Related Programming Questions

That is exactly right. Thank you.

When I re-arranged the data into the table I lost the association between the category names and the costs.

Thanks for the help,

B

Ok, here you go.

http://www.fileqube.com/file/unPFNJSHy206697

Hope this helps. Let me know if it needs any adjustments.

Edited by John D on 7/22/2009 at 9:55 PM

John,

That worked great. Thank you.

But I can't seem to find the accept button to pay you.

JB

Since you have already accepted I presume you were able to find the accept button and that there is no more problem in that regard.

Thanks and I look forward to assisting you again.