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!