Formula help please

[Luaptar]

Hi,

Good Morning!
I need your help to tweak this formula. I want to create a drop-down list that when ever I chose EXPORT, the details used will be in EXPORT sheet. I have different set of formula for every sheet and now I wanted it to be done on a single sheet even if the references will be based on what I choose in the list.

I saw a post about vlookup indirect but I can't manage to include it to my formula.

=IF(B2<=20,INDEX(EXPORT!C20:L59,E4,E6),B2*INDEX(EXPORT!C62:L68,LOOKUP(B2,{0,45,71,100,300,500,1000},{1,2,3,4,5,6,7}),SUMIF(EXPORT!$C$61:$L$61,B5,EXPORT!$C$60:$L$60)))


I hope somebody can help me with this.

 

[sheetspread]

You could add an if statement or lookup (with indirect should you need it)