Thanks to everyone, your input was great. I got Shane Devonshires to work
perfectly! I really appreciate all your help!

"T. Valko" wrote:

It would have been a good idea to show us some samples.

Here's a generic array formula** that should get you headed in the right
direction:

=INDEX(Sheet2!D1:D5,MATCH(TRUE,ISNUMBER(SEARCH(A1, Sheet2!C1:C5)),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"KCK" wrote in message
...
Hello, I am trying to use vlookup to match the contents of a cell with a
portion of a text string and return another cells data. Maybe using Index
and
Match would be better but I can't figure out how to accomplish this wtih
either of them.
For example: Sheet1 Column A contains a list of Sales Oder numbers, one
Sales Order per cell.
Sheet2 Column C contains several Sales Order numbers in each cell. Using
the Sales Order number in Sheet1 column A I need to find that Sales Order
number in Sheet2 Column C and return Column D to Sheet 1. Any help is
greatly appreciated!