=(VLOOKUP($O3,Import!$Q:$BV,13,FALSE)-(VLOOKUP($O3,'Old
Import'!$Q:$BV,13,FALSE)))/VLOOKUP($O3,'Old
Import'!$Q:$BV,13,FALSE)

Assuming the correct values are being looked up, this should do it.

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Doug" wrote:

I am using this formula to show a change is values. How can I get it to show
this as a percentage change?

=(VLOOKUP($O3,Import!$Q:$BV,13,FALSE)-(VLOOKUP($O3,'Old
Import'!$Q:$BV,13,FALSE)))

--
Thank you!