Return Certain Text with IF function
 

I have 12 pieces of machinery that all have their own id #s. Whenever I enter
in an a certain ID # in a cell I want it to copy from my master list what the
description of the machinery is and past that in to this cell.

Therefore I would type 15001 in cell C and in cell B it would type the
description of the equipment. Unfortunately I have more than 7 arguements and
I cannot figure out how to get around this. I'm currently using the following
formula:

=IF(C6=15001,'Equip List'!B6,IF(C6=20001,'Equip List'!B7,IF(C6=20002,'Equip
List'!B8,IF(C6=20003,'Equip List'!B9,IF(C6=20004,'Equip
List'!B10,IF(C6=20006,'Equip List'!B11,IF(C6=20007,'Equip
List'!B12,IF(C6=43002,'Equip List'!B13,0))))))))

The formula does work and types in what I want but only for 7 pieces of
equipment.

Return Certain Text with IF function
 

Take a look VLOOKUP function in Excel Help menu


"Robin Russell" wrote:

I have 12 pieces of machinery that all have their own id #s. Whenever I enter
in an a certain ID # in a cell I want it to copy from my master list what the
description of the machinery is and past that in to this cell.

Therefore I would type 15001 in cell C and in cell B it would type the
description of the equipment. Unfortunately I have more than 7 arguements and
I cannot figure out how to get around this. I'm currently using the following
formula:

=IF(C6=15001,'Equip List'!B6,IF(C6=20001,'Equip List'!B7,IF(C6=20002,'Equip
List'!B8,IF(C6=20003,'Equip List'!B9,IF(C6=20004,'Equip
List'!B10,IF(C6=20006,'Equip List'!B11,IF(C6=20007,'Equip
List'!B12,IF(C6=43002,'Equip List'!B13,0))))))))

The formula does work and types in what I want but only for 7 pieces of
equipment.

Return Certain Text with IF function
 

Thanks I was afraid of that, never used that funcation before. Will try

"Teethless mama" wrote:

Take a look VLOOKUP function in Excel Help menu


"Robin Russell" wrote:

I have 12 pieces of machinery that all have their own id #s. Whenever I enter
in an a certain ID # in a cell I want it to copy from my master list what the
description of the machinery is and past that in to this cell.

Therefore I would type 15001 in cell C and in cell B it would type the
description of the equipment. Unfortunately I have more than 7 arguements and
I cannot figure out how to get around this. I'm currently using the following
formula:

=IF(C6=15001,'Equip List'!B6,IF(C6=20001,'Equip List'!B7,IF(C6=20002,'Equip
List'!B8,IF(C6=20003,'Equip List'!B9,IF(C6=20004,'Equip
List'!B10,IF(C6=20006,'Equip List'!B11,IF(C6=20007,'Equip
List'!B12,IF(C6=43002,'Equip List'!B13,0))))))))

The formula does work and types in what I want but only for 7 pieces of
equipment.

Return Certain Text with IF function
 

Use a table of data, with a formula like

=VLOOKUP(C6,'Equip List'!$A$6:$B$17,2,False)

In Equip List A6:A17, enter the codes, and in B6:B17 enter the descriptions.

HTH,
Bernie
MS Excel MVP


"Robin Russell" <Robin wrote in message
...
I have 12 pieces of machinery that all have their own id #s. Whenever I enter
in an a certain ID # in a cell I want it to copy from my master list what the
description of the machinery is and past that in to this cell.

Therefore I would type 15001 in cell C and in cell B it would type the
description of the equipment. Unfortunately I have more than 7 arguements and
I cannot figure out how to get around this. I'm currently using the following
formula:

=IF(C6=15001,'Equip List'!B6,IF(C6=20001,'Equip List'!B7,IF(C6=20002,'Equip
List'!B8,IF(C6=20003,'Equip List'!B9,IF(C6=20004,'Equip
List'!B10,IF(C6=20006,'Equip List'!B11,IF(C6=20007,'Equip
List'!B12,IF(C6=43002,'Equip List'!B13,0))))))))

The formula does work and types in what I want but only for 7 pieces of
equipment.