| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alphabetical Code and matching data to a new worksheet
In the new cell, I want to type in an alphabetical letter to list possible
food codes and also other data related to this code, eg Description, Unit and Price/Unit, and to be able to select whichever one I want. eg. Worksheet with data A4 D4 E4 F4 Code Description Unit Price/Unit OLMA001 Olives, Manzanillo kg $25.20 I am having difficulty writing up a formula for this. Many thanks, Marty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alphabetical Code and matching data to a new worksheet
Take a VLOOKUP function in Help menu
"mda19652" wrote: In the new cell, I want to type in an alphabetical letter to list possible food codes and also other data related to this code, eg Description, Unit and Price/Unit, and to be able to select whichever one I want. eg. Worksheet with data A4 D4 E4 F4 Code Description Unit Price/Unit OLMA001 Olives, Manzanillo kg $25.20 I am having difficulty writing up a formula for this. Many thanks, Marty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find matching data in two worksheet columns | Excel Worksheet Functions | |||
| Retreiving font when matching data from one worksheet to another | Excel Discussion (Misc queries) | |||
| VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
| Removing a matching code from another cell | Excel Worksheet Functions | |||
| VBA Code for Matching and totalling columns | Excel Worksheet Functions | |||
Linear Mode
