0

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?

  • You need to use VBA. – NinjaCat May 5 '15 at 20:16
1

Using VBA you can do this by using this simple macro (assuming the data is on Sheet1) just assign it to a button or just run it through the VBA Macro Editor

Sub CopyCol()

    Sheets("Sheet1").Columns("B").Copy

    Sheets("Sheet1").Columns("C").PasteSpecial xlPasteValues

End Sub

Hope this helps!

  • A modification for use when Tables are used. – Tom Ruh May 6 '15 at 15:53
1

A modification for use when Tables are used.

Sub CopyCol()

    Range("Table8").Columns("B").Copy

    Range("Table8").Columns("C").PasteSpecial xlPasteValues

End Sub
-1

If I understand your question correctly, what you want in column C is the Vlookup VALUE you've gotten from Column A right?

If that's the case, you can just copy column B, paste as value only in column C. [Home > Paste > Paste Values]

  • Although this would work, I am looking for an answer that would use a function or macro – Tom Ruh May 6 '15 at 15:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.