Vlookup return %
 

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!

Vlookup return %
 

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

Vlookup return %
 

=(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.
--
Thank you!


"PJFry" wrote:

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

Vlookup return %
 

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


"PJFry" wrote:

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