Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default Formula Help... almost done with this project

Thanks in advance I am almost done with this project and have one more thing
that I need help with.

I have a Workbook called Quote TemplateBeta ver2 within the workbook I
have multiple worksheets The first sheet Info Sheet contains various
information for pricing countertops. I enter the information and it populates
the various quote sheets that correspond to the appropriate type of job.

On the Info Sheet I have the following cells

B22 (Type of job)
E10 (Material)
E16 (Price Group)

And I have quote sheets (within the same workbook) that correspond to the
various types of Jobs (wholesale, retail) and material (Granite, Silestone)

For this example lets say I have entered the following

B22 Wholesale
E10 Granite
E16 B

I need a formula that will return the amount from the appropriate cell
within the Granite-Wholesale worksheet to the Info Sheet M14

E61 Total A
F61 Total B
G61 Total C
H61 Total D

I have 4 types of material and 3 different job types. I think I can modify
the formula once somebody gets me on the right track.

Thanks
Steve

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help... almost done with this project Max Excel Worksheet Functions 3 March 28th 07 01:08 AM
Formula Help... almost done with this project Max Excel Worksheet Functions 1 March 28th 07 12:08 AM
How to convert MS Project to MS Excel. I don't have MS Project. Jane Excel Discussion (Misc queries) 1 February 20th 06 10:01 PM
Help with a project MC82 Excel Discussion (Misc queries) 3 January 20th 06 12:11 AM
Need a project. bach New Users to Excel 6 August 30th 05 09:47 AM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"