vlookup answer in different cell
 

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.

vlookup answer in different cell
 

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.

Psychlogic wrote:

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.

--

Dave Peterson