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!