| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding text
Hi
I have a colum that has a ID numbers as follows A B C D E 1 E1234 E32185 E321 2 E8954 EC123 EE123 3 E3215 EE124 E4564 In another column in receive ID numbers say EE123 i need a formula that will search column A and return the first ID where EE123 exists via =Mid(1,find(" ") as ID are between 4-6 characters long. So for EE123 the result would be E8954. All help is greatly appreciated. -- _______________________ Naz, London |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a text box | Excel Worksheet Functions | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding Buried Text | Excel Discussion (Misc queries) | |||
| Finding a particular text | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
