Setting a value from a formula

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

I have a cell which contains a formula. Is there an easy way to change it
to a value without doing a paste(special)?
Also I have failed to be able to work out how to easily do a Vlookup based
upon this cell and to replace it with a new value without copying it to a
new cell and then referencing the lookup from that one? Underlying all this
I have been trying to set a variable to the cell value and then doing a
lookup using the variable but the syntax would'nt work??
A green one!
 
Hi Mervyn

Check out this page for examples that are using the Value property.
http://www.rondebruin.nl/values.htm

You second quistion I thinkk I don't understand but

=VLOOKUP(C1,A1:B8,2)
In this formula is the value in C1 the variable lookup value
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup result in a message box 10
Vlookup error 5
Indirect formula errors if file is closed 1
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1
HELP!!! I can't set formula to cell 1
Vlookup formula entered by VBA, returns from another worksheet 3
Formula appearing as Value in Formula Bar 1
Syntax in worksheet functions for individual values instead of ranges 5

Back
Top