VLOOKUP Nested in IF Statement

[onei8316]

I'm trying to embed a vlookup into an if statement.

My formula is the following:

=IF(I3>50%,VLOOKUP($B3,Sheet3!A:J,10, FALSE),"10% off any service over $100")

I bascially want the VLOOKUP to be the "True" return. If I3 is more than 50%, then Vlookup from the other sheet, if it's less than 50% then say "10% off any service over $100".

Someone help please!

 

[Asala42]

I'm not sure I see the problem.
The formula looks right to me, at least with respect to syntax and the intent from your description.