Eduardo,

KCK want to do the lookup when A1 is part of the string in a cell in
Sheet2!C...

Also Excel 2003 works with
=Vlookup(A1,sheet2!C:D,2,false)

Absolute reference is not required since you are using the whole column...


"Eduardo" wrote:

Hi,
In sheet1 column B enter
=Vlookup(A1,sheet2!$C:$D,2,false), if not using excel 2007 use
=Vlookup(A1,sheet2!$C1:$D1000,2,false),


"KCK" wrote:

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!