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

It's OK. I will just make a little macro to copy the result of the formula and paste special (value) into the required cell.

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

__________________
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

OK, I will try that too.
Many thanks
Steve

If you still want to copy as originally asked in your question just write a lil macro
E.G.
Sub CopyValue()
Range("G5").Select
Selection.Copy
Range("D8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub