VLookup for test

[Frank Kabel]

Hi
try
=VLOOKUP(D2,'2003'!D2:E154,2,0)

-----Original Message-----
Hello.

I have a list of 300 names (all unique) in one sheet,

with various information going across the row.

I want to take a portion of that data and place it into a

2nd sheet, but the names on the 2nd are not in the same
order, nor are they all present in the first sheet.

This is what I thought would work:
=VLOOKUP(D2,'2003'!D2154,8)

It looks as though it will not search my column for the

text. What am I doing wrong? Any suggestions?