Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a Value from a Table, dependant on the word Typed
Hi
I'm trying return the weight of an item into an adjacent cell, when I type the word. To Explain: If I have A1 and B1 as Item and Weight, then underneath those I have Sofa, Chair, Bed etc, with the relevant weights in the B Column. Next I have another Worksheet or the Same Worksheet, where I have Name, Item and Weight. I want to insert automatically the Weight based on typing the right Item (i.e. Sofa) in the cell next to the persons name. Hope that makes sense. Can't seem to upload a sample. I may have about 100 items to access along with their weights. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fitting cell to typed word | Excel Discussion (Misc queries) | |||
Why does the word typed "true" automatically turn to ALL CAPS? | New Users to Excel | |||
Returning a Value dependant on a cell which could have different d | Excel Worksheet Functions | |||
when word is typed in cell, how can the row auto displays data? | Excel Discussion (Misc queries) | |||
copy a number typed in a cell to another & change it to word form. | Excel Discussion (Misc queries) |