I'm trying to put together a Vlookup, but i'm having problems as the lookup value contains the data i want to lookup rather than being an exact match.
In Sheet1 Column G i have the following (just a sample)
2880-00000064-METZROTH V 011111<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
Accrual - Brunning<o></o>
2880-00000074-O'SHEA B 011111<o></o>
142776 SOZANSKY S<o></o>
A1000-00005272-L McLeavy-M13.12-020<o></o>
A1000-00006546-S G Ager-Exps-06.01-
These are all Surnames
In Sheet2 Column B I have a list of all of the possible surmanes which could be contained in the Sheet1 Column G (283 rows)
In Sheet2 Column A I have the full names in the format i require.
Is there a formula or some vba i can use to say 'if a cell in Sheet1 column G contains the value of any cell in Sheet2 Column B then return the value of the corresponding Cell in Sheet2 ColumnA int Sheet1 Column I
e.g if lookup value contains Sheet2 B2, reurn Sheet2 A2
If any one can help this would be much appreciated.
Chuggs
In Sheet1 Column G i have the following (just a sample)
2880-00000064-METZROTH V 011111<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>Accrual - Brunning<o
></o>2880-00000074-O'SHEA B 011111<o
></o>142776 SOZANSKY S<o
></o>A1000-00005272-L McLeavy-M13.12-020<o
></o>A1000-00006546-S G Ager-Exps-06.01-
These are all Surnames
In Sheet2 Column B I have a list of all of the possible surmanes which could be contained in the Sheet1 Column G (283 rows)
In Sheet2 Column A I have the full names in the format i require.
Is there a formula or some vba i can use to say 'if a cell in Sheet1 column G contains the value of any cell in Sheet2 Column B then return the value of the corresponding Cell in Sheet2 ColumnA int Sheet1 Column I
e.g if lookup value contains Sheet2 B2, reurn Sheet2 A2
If any one can help this would be much appreciated.
Chuggs
