A couple of nit-picking questions:
1) I hope the formula is =VLOOKUP(A1,'sheet2'!$A$10:$I$24,9,FALSE)
without the quotes
2) This formula is in B1 so the results will be in B1 not in A1
So QUOTE less than or equal to 2% place a value of 80% in cell a1 QUOTE
should reference B1 not A1
3) Why not add a column H, starting in H10 with =IF(H10<=2%,90%,
IF(H10<=4%,80%, 120%)) and copy down to H24
or use on sheet1
=IF(your-formula<=2%,90%, IF(your-formula<=4%,80%, 120%))
I do hope I have understood your need
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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