vlookup answer in different cell

P

Psychlogic

Can i write a vlookup formula but have the answer placed in a different cell?
(that is, write the formula in , let's say, B1 but have the result appear in
C3) And if so, can i easily make that cell a value?) I know i can copy and
repaste as a valuie but I would like to do it automatically.
 
D

Dave Peterson

Nope. Formulas can only return values to the cell that holds them.

But if you want to override some formulas with manual entries, this is what I
do:

I have a column for the formula (say cell c2).

=somestrangeformulahere

Then in D1, I have a header: Manual Override

And allow the user to type anything they want in D2.

In E1, I have Value used: (another header)

=if(d2<>"",d2,c2)
(in E2)

Then I use E2 in every other formula.
 
Top