To be fair - his original post asked
"Is it possible to have a function (e.g. If function) post a result into an
alternative cell"



"Tyro" wrote:

You should have stated originally what you were trying to do, rather than
wasting our time and effort.

"Les G" wrote in message
...
Hi Tyro,
I am actually trying to produce a 'program' that my users can use to
select
data from a dropdown box. The dropdown box will put a result into a cell
which will then used in a vlookup function nested within an if function to
'push' data into other cells. For various reasons, I don't want the
destination cells to have formulas. I can do it using VBA, but mentioned
earlier wanted to try and do without VBA.

Biff, the microsoft Excel MVP advises that this can't be done. Thanks for
your help anyway.