Hi,
Good Afternoon!
I was able to include the Indirect Function by the help of Spreadsheet but now I need to get a function the will then choose 2 options on each sheet.
Scenario:
Sheet 1 - Export Sheet ** 2 options Document Rates or Non-Document Rates
Noted: Rates are on different cell ranges
Sheet 2 - Import Sheet ** 2 options Document Rates or Non-Document Rates
Noted: Rates are on different cell ranges
The format for both sheets are the same. The only thing that is different are the rates on the sheets.
This is the formula for Non Document rates which is currently working well.
=IF(B2<=20,INDEX(INDIRECT(A1&"!C20:L59"),D4,D6),B2*INDEX(INDIRECT(A1&"!C62:L68"),LOOKUP(B2,{0,45,71,100,300,500,1000},{1,2,3,4,5,6,7}),SUMIF(INDIRECT(A1&"!$C$61:$L$61"),B5,INDIRECT(A1&"!$C$60:$L$60"))))
This is the formula for Document rates.
=IF(F2<=5,INDEX(EXPORT!C7:L16,H4,H6))
What I want to do is that I will have 2 drop down list for IMPORT/EXPORT & for Documents/Non Documents.
What formula shall I use to make this work?
Thanks,
Luaptar
Good Afternoon!
I was able to include the Indirect Function by the help of Spreadsheet but now I need to get a function the will then choose 2 options on each sheet.
Scenario:
Sheet 1 - Export Sheet ** 2 options Document Rates or Non-Document Rates
Noted: Rates are on different cell ranges
Sheet 2 - Import Sheet ** 2 options Document Rates or Non-Document Rates
Noted: Rates are on different cell ranges
The format for both sheets are the same. The only thing that is different are the rates on the sheets.
This is the formula for Non Document rates which is currently working well.
=IF(B2<=20,INDEX(INDIRECT(A1&"!C20:L59"),D4,D6),B2*INDEX(INDIRECT(A1&"!C62:L68"),LOOKUP(B2,{0,45,71,100,300,500,1000},{1,2,3,4,5,6,7}),SUMIF(INDIRECT(A1&"!$C$61:$L$61"),B5,INDIRECT(A1&"!$C$60:$L$60"))))
This is the formula for Document rates.
=IF(F2<=5,INDEX(EXPORT!C7:L16,H4,H6))
What I want to do is that I will have 2 drop down list for IMPORT/EXPORT & for Documents/Non Documents.
What formula shall I use to make this work?
Thanks,
Luaptar