| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Vlookup then interpolate,return corresponding value, if not, return other value | Excel Worksheet Functions | |||
| vlookup w/ more than one return value | Excel Discussion (Misc queries) | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| VLOOKUP to return first hit | Excel Worksheet Functions | |||
| VBA Syntax for VLOOKUP to return array of return values | Excel Programming | |||
Hybrid Mode
