| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill in text from another cell
I am working on an inventory of equipment, and have a dropdown for the make
of equipment, and would like to have the model cell populate with the model number of the peice of equipment automaticly, i.e. if the make is "chair" then the model is "P1234". all the "makes" have only one model number to them, i have 5 differant makes so only 5 differant models. any help would be great. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
fill in text from another cell
Assumption:
1. You have make dropdown in A1 and you want the model in B1 of Sheet1. 2. You have 'make' in A1-A5 of sheet2 and 'model' in B1-B5 Enter this in B1 of Sheet1 =IF(ISNA(VLOOKUP(A1,Sheet2!A:B,2,False),"",VLOOKUP (A1,Sheet2!A:B,2,False)) "Godspeed" wrote: I am working on an inventory of equipment, and have a dropdown for the make of equipment, and would like to have the model cell populate with the model number of the peice of equipment automaticly, i.e. if the make is "chair" then the model is "P1234". all the "makes" have only one model number to them, i have 5 differant makes so only 5 differant models. any help would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the cell colour fill when pasting in text? | Excel Discussion (Misc queries) | |||
| count if cell if fill with text | Excel Worksheet Functions | |||
| weird no more cell fill and text colour | Excel Discussion (Misc queries) | |||
| How to auto-fill text based on text in another cell | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Linear Mode
