[FONT="]Based on what's in cell A3 (3%, 7%, or 10%) I want it to choose one of my three corresponding support matrix workbooks; “3%SUPPORT”, “7%SUPPORT”, “10%SUPPORT” and then using VLOOKUP cross reference the total number of new licenses in A4 and give me the new support amount in A5 which is in the 2<sup>nd</sup> column of each of the 3 worksheets. The 1<sup>st</sup> column contains the number of licenses. [/FONT]
[FONT="]
[/FONT]
[FONT="]A1= Current number of licenses.[/FONT]
[FONT="]A2= Current annual support amount.[/FONT]
[FONT="]A3= Annual Renewal %. Data validation only allows 3%, 7%, or 10% to be[/FONT]
[FONT="] entered.[/FONT]
[FONT="]A4=New total number of licenses. This will be different each time. [/FONT]
[FONT="]A5= New support amount based on the new number of licenses.[/FONT]
[FONT="]
[/FONT]
[FONT="]Basic Example Below[/FONT]
[FONT="]A1 = 50 (Current number of licenses)
[/FONT]
[FONT="]A2 = $200.00 (Current annual support amount)
[/FONT]
[FONT="]A3= 3% | 7% | 10% (This client is using the 3% support matrix)
[/FONT]
[FONT="]A4= 100 (New number of licenses)
[/FONT]
[FONT="]A5= $250.00 Auto populates A5 with the new support amount for 100[/FONT]
[FONT="] licenses from the 3% matrix worksheet. If 7% was chosen in
[/FONT]
[FONT="] A3 it would have populated A5 with $251.00 and the 10%[/FONT]
[FONT="] worksheet would have = $269.00)[/FONT]
[FONT="]3% Support[/FONT][FONT="]worksheet; A = Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $242.00[/FONT]
[FONT="]100 [/FONT][FONT="]$250.00[/FONT]
[FONT="]101 $252.50[/FONT]
[FONT="]7% Support[/FONT][FONT="] worksheet A = Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $253.00[/FONT]
[FONT="]100 $251.00[/FONT]
[FONT="]101 $255.75[/FONT]
[FONT="]10% Support[/FONT][FONT="] worksheet A= Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $261.00[/FONT]
[FONT="]100 $269.00[/FONT]
[FONT="]101 $272.25[/FONT]
[FONT="]Thank you for your help.[/FONT]
[FONT="]
[/FONT]
[FONT="]A1= Current number of licenses.[/FONT]
[FONT="]A2= Current annual support amount.[/FONT]
[FONT="]A3= Annual Renewal %. Data validation only allows 3%, 7%, or 10% to be[/FONT]
[FONT="] entered.[/FONT]
[FONT="]A4=New total number of licenses. This will be different each time. [/FONT]
[FONT="]A5= New support amount based on the new number of licenses.[/FONT]
[FONT="]
[/FONT]
[FONT="]Basic Example Below[/FONT]
[FONT="]A1 = 50 (Current number of licenses)
[/FONT]
[FONT="]A2 = $200.00 (Current annual support amount)
[/FONT]
[FONT="]A3= 3% | 7% | 10% (This client is using the 3% support matrix)
[/FONT]
[FONT="]A4= 100 (New number of licenses)
[/FONT]
[FONT="]A5= $250.00 Auto populates A5 with the new support amount for 100[/FONT]
[FONT="] licenses from the 3% matrix worksheet. If 7% was chosen in
[/FONT]
[FONT="] A3 it would have populated A5 with $251.00 and the 10%[/FONT]
[FONT="] worksheet would have = $269.00)[/FONT]
[FONT="]3% Support[/FONT][FONT="]worksheet; A = Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $242.00[/FONT]
[FONT="]100 [/FONT][FONT="]$250.00[/FONT]
[FONT="]101 $252.50[/FONT]
[FONT="]7% Support[/FONT][FONT="] worksheet A = Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $253.00[/FONT]
[FONT="]100 $251.00[/FONT]
[FONT="]101 $255.75[/FONT]
[FONT="]10% Support[/FONT][FONT="] worksheet A= Number of licenses B=New support amount[/FONT]
[FONT="]A B[/FONT]
[FONT="]99 $261.00[/FONT]
[FONT="]100 $269.00[/FONT]
[FONT="]101 $272.25[/FONT]
[FONT="]Thank you for your help.[/FONT]
