Thread: [Solved] Show result of formula as a value in another cell
View Single Post
 
Old 09-10-2014, 09:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by Steve_D View Post
Hi
I have a formula that returns a value (number) in cell G5. I would like that value to appear as just the value in another cell (D8), so it can be used by another (index match) formula.
If I just put =G5 in cell D8, I don't think the second formula will work, as it will be looking to match "=G5" rather than the number itself.
Is there a solution?
Thanks
If you enter =G5 without quotes, the MATCH will look for the values. But why bother, why noy use G5 in your MATCH formula? No macros or anything fancy needed
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote