Multiple If/Then formulas in one cell
 

Hi.

I need to use multiple instances of IF/Then formulas in one cell. How would
I do this?

Here's the situation, so that you might get a better understanding:
I have one cell where a contractors name appears on a sheet. We use multiple
contractors on a regular basis. What I'd like to do is under that name cell,
automatically fill in the contractor's address. We've had lots of problems
with employees either putting the wrong info into these cells, or just no
info what so ever, so I just figured I could make a bank of contractor
addresses off to the side, hide the column, and use an if/then to reference
them.

Any help would be appreciated! Thanks!

Multiple If/Then formulas in one cell
 

Use the VLOOKUP() function instead.

Here's a tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Korwin" wrote in message ...
| Hi.
|
| I need to use multiple instances of IF/Then formulas in one cell. How would
| I do this?
|
| Here's the situation, so that you might get a better understanding:
| I have one cell where a contractors name appears on a sheet. We use multiple
| contractors on a regular basis. What I'd like to do is under that name cell,
| automatically fill in the contractor's address. We've had lots of problems
| with employees either putting the wrong info into these cells, or just no
| info what so ever, so I just figured I could make a bank of contractor
| addresses off to the side, hide the column, and use an if/then to reference
| them.
|
| Any help would be appreciated! Thanks!

Multiple If/Then formulas in one cell
 

Hi Korwin,

I would use a vlookup function, with a table listing all the contractors and
their addresses.
If you would like a suggestion on how to use vlookup, just say.

Mark

"Korwin" wrote:

Hi.

I need to use multiple instances of IF/Then formulas in one cell. How would
I do this?

Here's the situation, so that you might get a better understanding:
I have one cell where a contractors name appears on a sheet. We use multiple
contractors on a regular basis. What I'd like to do is under that name cell,
automatically fill in the contractor's address. We've had lots of problems
with employees either putting the wrong info into these cells, or just no
info what so ever, so I just figured I could make a bank of contractor
addresses off to the side, hide the column, and use an if/then to reference
them.

Any help would be appreciated! Thanks!

Multiple If/Then formulas in one cell
 

Excel has a feature call VLOOKUP that meets your specific need. See Excel
Help.
--
Gary''s Student - gsnu200766


"Korwin" wrote:

Hi.

I need to use multiple instances of IF/Then formulas in one cell. How would
I do this?

Here's the situation, so that you might get a better understanding:
I have one cell where a contractors name appears on a sheet. We use multiple
contractors on a regular basis. What I'd like to do is under that name cell,
automatically fill in the contractor's address. We've had lots of problems
with employees either putting the wrong info into these cells, or just no
info what so ever, so I just figured I could make a bank of contractor
addresses off to the side, hide the column, and use an if/then to reference
them.

Any help would be appreciated! Thanks!

Multiple If/Then formulas in one cell
 

Well, VLOOKUP is about 1.5 billion times easier to do then what I was
thinking.

Thank you all!

"Gary''s Student" wrote:

Excel has a feature call VLOOKUP that meets your specific need. See Excel
Help.
--
Gary''s Student - gsnu200766


"Korwin" wrote:

Hi.

I need to use multiple instances of IF/Then formulas in one cell. How would
I do this?

Here's the situation, so that you might get a better understanding:
I have one cell where a contractors name appears on a sheet. We use multiple
contractors on a regular basis. What I'd like to do is under that name cell,
automatically fill in the contractor's address. We've had lots of problems
with employees either putting the wrong info into these cells, or just no
info what so ever, so I just figured I could make a bank of contractor
addresses off to the side, hide the column, and use an if/then to reference
them.

Any help would be appreciated! Thanks!