Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help... almost done with this project | Excel Worksheet Functions | |||
Formula Help... almost done with this project | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Help with a project | Excel Discussion (Misc queries) | |||
Need a project. | New Users to Excel |