View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
S Willingham S Willingham is offline
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