I am looking for a way to project a cells value in a different cell. Scenerio:
- Column A = Value
- Column B = Vlookup from A
- Column C = I would like to be ONLY the value from B not the formula.
Is it possible to do this with the Indirect function? Or do I need VBA?