| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I find items that have a certain prefix and define?
I have one file (file A) that has many items and these items all begin with
different prefixes(ex. aaa123456). I have another file (file B)that can identify what the prefix means. This file B has the 3-digit prefix in column A, the full name of the prefix in column B. How can I add a new column in File A that has the full name of the prefix by creating a formula to look at File A, and if it contains a prefix that is on File B, it will add the corresponding name to that row? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
| Find Count of Items with certain criteria | Excel Discussion (Misc queries) | |||
| where can I find a sample home inventory that list all items i ma. | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Threaded Mode
