Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup results in different cell
Can the results of a vlookup be sent to a cell other than the one the formula
is in? Can't protect the cell where the data needs to be as that cell needs the option to fill in data not found in the vlookup array. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup results in different cell
using a formula in c1 use
=a1 to get the info in a1 -- Don Guillett Microsoft MVP Excel SalesAid Software "pamber" wrote in message ... Can the results of a vlookup be sent to a cell other than the one the formula is in? Can't protect the cell where the data needs to be as that cell needs the option to fill in data not found in the vlookup array. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup results in different cell
Where in the following formula would you include '=a1' in order to get the
result from cell c1 to a1? =VLOOKUP(K25,'Drop Down Data'!$T$3:$W$426,2) Thanks for your help! "Don Guillett" wrote: using a formula in c1 use =a1 to get the info in a1 -- Don Guillett Microsoft MVP Excel SalesAid Software "pamber" wrote in message ... Can the results of a vlookup be sent to a cell other than the one the formula is in? Can't protect the cell where the data needs to be as that cell needs the option to fill in data not found in the vlookup array. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup results in different cell
Formulas cannot "send" results to other cells.
What Don is saying...........assuming the VLOOKUP result is in C1 enter =C1 in cell A1 to have the C1 results placed in A1 also. But this won't do you any good if you will be overwriting the C1 VLOOKUP formula with a typed entry as you wish. A cell can hold a formula or a typed in value, not both. Re-design is your only hope if you intend to overwrite formulas with typed values. Gord Dibben MS Excel MVP On Sun, 16 Sep 2007 14:08:01 -0700, pamber wrote: Where in the following formula would you include '=a1' in order to get the result from cell c1 to a1? =VLOOKUP(K25,'Drop Down Data'!$T$3:$W$426,2) Thanks for your help! "Don Guillett" wrote: using a formula in c1 use =a1 to get the info in a1 -- Don Guillett Microsoft MVP Excel SalesAid Software "pamber" wrote in message ... Can the results of a vlookup be sent to a cell other than the one the formula is in? Can't protect the cell where the data needs to be as that cell needs the option to fill in data not found in the vlookup array. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup results in different cell
Thanks for the confirmation. I had pretty much already decided it could not
be done, but............. "Gord Dibben" wrote: Formulas cannot "send" results to other cells. What Don is saying...........assuming the VLOOKUP result is in C1 enter =C1 in cell A1 to have the C1 results placed in A1 also. But this won't do you any good if you will be overwriting the C1 VLOOKUP formula with a typed entry as you wish. A cell can hold a formula or a typed in value, not both. Re-design is your only hope if you intend to overwrite formulas with typed values. Gord Dibben MS Excel MVP On Sun, 16 Sep 2007 14:08:01 -0700, pamber wrote: Where in the following formula would you include '=a1' in order to get the result from cell c1 to a1? =VLOOKUP(K25,'Drop Down Data'!$T$3:$W$426,2) Thanks for your help! "Don Guillett" wrote: using a formula in c1 use =a1 to get the info in a1 -- Don Guillett Microsoft MVP Excel SalesAid Software "pamber" wrote in message ... Can the results of a vlookup be sent to a cell other than the one the formula is in? Can't protect the cell where the data needs to be as that cell needs the option to fill in data not found in the vlookup array. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with two results | Excel Discussion (Misc queries) | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
vlookup: I have to double click each cell to get correct results? | Excel Worksheet Functions | |||
format cell based on results of vlookup function | Excel Worksheet Functions | |||
VLOOKUP - results do not appear in cell | Excel Worksheet Functions |