Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions | |||
vlookup search for more then one answer | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions |