Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help! I need multiple formulas for one cell! | Excel Discussion (Misc queries) | |||
Help! I need multiple formulas for one cell. | Excel Worksheet Functions | |||
Multiple Formulas in same cell | Excel Worksheet Functions | |||
multiple formulas in one cell | Excel Worksheet Functions | |||
Using a single cell in multiple formulas | Excel Worksheet Functions |