Multiple If/Then formulas in one cell

[Korwin]

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!

 

[Niek Otten]

Use the VLOOKUP() function instead.

Here's a tutorial:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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!

 

[Mark Costello]

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

 

[Gary''s Student]

Excel has a feature call VLOOKUP that meets your specific need. See Excel
Help.

 

[Korwin]

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

Thank you all!