I have 1 workbook that has two worksheets, I'm using Excel 2003. The cell in
the first worksheet has a # that I want to lookup in the 2nd worksheet to see
if it exists. the problem is the cell in the table_array may contain more
than just the #.

for example

cell in worksheet #1 = "123456"
the cell I want to find in worksheet #2 has "AR 123456 this is a test"

I would expect the vlookup to be able to do an approximate match and
recognize the "AR 123456 test is a test" but it comes back with "NA". I
don't know what I'm doing wrong, was wondering if there is some help out
there.