| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP with value contained within text
Can someone please help.
I am trying to perform a vlookup where the value is contained within the text of the cell and there is no common pattern as to where the value starts (eg could start in position 1 or 25) An example: The value is contained within the following cell in "Sheet 1" - A/C M98603521 GOLDMAN SACH Within the array in "Sheet 2" Column A Column B GOLDMAN SACH GOLSAC1012 .... .... I would like to lookup A/C M98603521 GOLDMAN SACH and return GOLSAC1012. Thanks Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find partial text contained in another cell | Excel Discussion (Misc queries) | |||
| When I import a csv file text that contained a + gets scrambled | Excel Discussion (Misc queries) | |||
| Countif function for instances of text string contained | Excel Worksheet Functions | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| searching a cell for a contained text word | Charts and Charting in Excel | |||
Threaded Mode
