IF function

L

Lee

I'm using the IF function so that excel auntomatically
inputs the item code by looking at the item name. I know
how to write the basic formula. But what I'm looking to
do, is put the formula in cell H5 for example, and have
the outcome put in cell I5. This may sound like a strange
thing to do, but there is a very valid reason for doing
this. Is this possible and if so, how!
 
B

Biff

Not possible. A formula cannot "put" a value in any cell
other than the cell it's in.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A couple questions BEFORE using Office 365 0
Display weeks from a Milestone 0
Return blank cell if data cell is blank 4
Invoicing and customer database 0
Multi-Selection with Hand-writing draw tool 0
Return a value if a range of cells contain text 2
Conditions 2
VLOOKUP & Data Validation 0

Top