| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert function return value to text? | Excel Worksheet Functions | |||
| Need function to return text value | Excel Worksheet Functions | |||
| Need Function to look up value and return a text value? | Excel Worksheet Functions | |||
| What function do I use to return a certain value for specific text | Excel Discussion (Misc queries) | |||
| Need subtotal function to return text as result | Excel Discussion (Misc queries) | |||
Threaded Mode
