Help automating this IF formula to generate estimated cost

[Arinoum]

Hi,
I'm trying to create a pricing calculator that automatically calculates the cost of a service depending on which vendor is used and what service line. Tab one has the calculator and tab two has a list of vendors and their services and different rates for these services. See below example:

TAB ONE: C2&3 is a drop down that pulls from tab two a1:G1 (the vendor names). D2&3 pull from tab two a3:a12 (the turn around time) I want to add a formula on F2 to calculate the cost. Something like If C2 = Lori and D2 = 1 business day then return this formula =(7*amount in E2). Any help is greatly appreciated.

	SERVICE	VENDOR	TURN AROUND TIME	ESTIMATED QTY	COST
T
C

TAB TWO:

 

[afonsomira]

Hello.

See if is this that you need.

Paste this on range"F2" - =IFERROR(INDEX('TAB TWO'!A1:G12,MATCH(D2,'TAB TWO'!A1:A12,0),MATCH(C2,'TAB TWO'!B1:G1,0)+1)*E2,0)

Paste this on range "F3" - =IFERROR(INDEX('TAB TWO'!A1:G12,MATCH(D3,'TAB TWO'!A1:A12,0),MATCH(C3,'TAB TWO'!B1:G1,0)+2)*E3,0)

 

[Arinoum]

Hello.

See if is this that you need.

Paste this on range"F2" - =IFERROR(INDEX('TAB TWO'!A1:G12,MATCH(D2,'TAB TWO'!A1:A12,0),MATCH(C2,'TAB TWO'!B1:G1,0)+1)*E2,0)

Paste this on range "F3" - =IFERROR(INDEX('TAB TWO'!A1:G12,MATCH(D3,'TAB TWO'!A1:A12,0),MATCH(C3,'TAB TWO'!B1:G1,0)+2)*E3,0)

Thank you so much!!!