Vlookup return %

[Doug]

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)))

 

[PJFry]

=(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.

 

[Doug]

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

I tried yours and this one also and it only returns N/A.

 

[Doug]

I finally got it to work.
--
Thank you!

=(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.