On Sep 1, 2:48 pm, Max wrote:
Replace this term: VLOOKUP(D10,Customers,9)
with this: TEXT(ROUND(VLOOKUP(D10,Customers,9),2),"0%")
--

Shoot! Didn't finish that off properly. Ignore my first post.

2nd try, if the OP wants a percent with 2 decimal places:
TEXT(ROUND(VLOOKUP(D10,Customers,9),4),"0.00%")