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