nesting if functions

swtpike · May 28th, 2002, 07:47 AM

I have 17 peoples' names who work for 7 different companies. I would like to be able to enter one of the names in a cell (Customer Representative)and have their company's name show up in another cell(Company). I can't figure out how to do this without using 17 nested if functions. Any suggestions would be greatly appreciated. Thanks.

Iain Lewis · May 28th, 2002, 07:58 AM

Try the LookUp functions ( VLOOKUP, HLOOKUP ). Usually for this I'd use VLOOKUP.

Create a list of Names in Col A & their Company in Col B. You could use any columns, but the Company will have to be in a column to the right of the Name.

Assuming you have the name in C1 & want the Company in D1 put the following formula in D1 :

=vlookup(C1,A1:B10,2,0)

A1 to B10 is the range of Names & Companies, the "2" means "when you find the match for C1 show me the value in the second column of the lookup range ie B " & the "0" means "exact matches only".

HTH

Iain

Asala42 · May 28th, 2002, 07:59 AM

You could make a small table of names with their corresponding companies and then use a VLOOKUP.

Aladin Akyurek · May 28th, 2002, 08:01 AM

Quote:

On 2002-05-28 07:47, swtpike wrote:
I have 17 peoples' names who work for 7 different companies. I would like to be able to enter one of the names in a cell (Customer Representative)and have their company's name show up in another cell(Company). I can't figure out how to do this without using 17 nested if functions. Any suggestions would be greatly appreciated. Thanks.

Make a 2-column list like

Bob Company1
Bill Company1
Rob Company3
etc.

Suppose that this list is in A2:B18, you can use

=VLOOKUP("Rob",$A$2:$B$18,2,0)

to retieve the company a-name is associated with. You can use a cell instead of "Bob", a cell that contains a name of interest.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 28th, 2002, 07:47 AM	#1
swtpike New Member Join Date: May 2002 Posts: 12	I have 17 peoples' names who work for 7 different companies. I would like to be able to enter one of the names in a cell (Customer Representative)and have their company's name show up in another cell(Company). I can't figure out how to do this without using 17 nested if functions. Any suggestions would be greatly appreciated. Thanks.

May 28th, 2002, 07:58 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Try the LookUp functions ( VLOOKUP, HLOOKUP ). Usually for this I'd use VLOOKUP. Create a list of Names in Col A & their Company in Col B. You could use any columns, but the Company will have to be in a column to the right of the Name. Assuming you have the name in C1 & want the Company in D1 put the following formula in D1 : =vlookup(C1,A1:B10,2,0) A1 to B10 is the range of Names & Companies, the "2" means "when you find the match for C1 show me the value in the second column of the lookup range ie B " & the "0" means "exact matches only". HTH Iain

May 28th, 2002, 07:59 AM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,306	You could make a small table of names with their corresponding companies and then use a VLOOKUP.