| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup a value within a text string
I have a column with text which I want to use as basis for choosing account
based on rules in a separate columnst. Text in A1: 01.02 7-ELEVEN Heathrow Rule in r1: 7-ELEVEN Account in s1: 400 I want a formula in B1 which looks up the account number from colum s when any part of the text string in A1 matches text in column r. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| lookup or find matching number in text string | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Threaded Mode
