Vlookup help
I have just reqlized that I did not provide you the correct infomation to
assist. The correct info is below
Sheet 1 is my summary page
Column A contains sales reps ID (a1= 1234)
Column B will contain the required formula that will determine commission
results
Sheet 2 is the source page
Vlookup range is 'sheet2'!$A$10:$I$24
Cell D3 contains target of 7.8% (this value could can change YOY)
Cell E3 contains target of 7.3%
Cell F3 contains target of 6.5%
Need a formula that will vlookup 'sheet2'!$A$10:$I$24 and if that number is
less than or equal to 6.5% place a value of 200 % in Sheet 1 cell B1. If the
number is
greater than 6.5% but less than or eqaul to 7.3%, place a value of 100% in
Sheet 1 cell
B1, if the number is greater than 7.3% but less than 7.8% place a value of
80% and lastly if the number is greater than 7.8% place a 0%
sry and thanks
"PCLIVE" wrote:
If you want to do your calculations all in one shot, then maybe something
like this.
=IF(VLOOKUP(A1,Sheet2!$A$10:$I$24,9,"false")<=2%,8 0%,IF(VLOOKUP(A1,Sheet2!$A$10:$I$24,9,"false")4%, 120%,90%))
Regards,
Paul
--
"Curtis" wrote in message
...
Sheet 1
cell a1 = vlookup data
cell b1 is where I want Vlook up results...curent formla is
=VLOOKUP(A1,'sheet2'!$A$10:$I$24,9,"false")
Sheet 2
vlookup range = 'sheet2'!$A$10:$I$24
Need a formula that will vlookup cell a1 in sheet one and if that number
is
less than or equal to 2% place a value of 80% in cell a1. If the number is
greater than 2 % but less than or eqaul to 4%, place a value of 90% in
cell
A1, and if the number is greater than 4%, place a value of 120%
hope that makes sense
Thanks
|