You can't. Assuming your formula below is in cell c1 and you want to ALSO
see it in a1 then in cell a1 put =c1. If you only want it to be in cell a1
put the formula in cell a1.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pamber" wrote in message
...
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.