| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for finding text
What formula should I use to lookup a piece of text from a
list of entries in for example colomn a I want to lookup apple and if found then return the data from colomn b i.e. AP into cell 5a. A B 1 Potato PO 2 Carrot CA 3 Apple AP 4 Swede SW 5 Formula result It sounds simple but I can only get matches to work with numbers and not text. Any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with formula: finding text | Excel Worksheet Functions | |||
| Finding text | Excel Worksheet Functions | |||
| Finding text | Excel Worksheet Functions | |||
| Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Threaded Mode
