Sorry I just noticed that you just want the first six digits. Here is an easy
formula

=value(left(A1, 6))

Where the number you want to look up is in cell A1... :) I thought your #
was somewhere anywhere in the number...front, back, middle...

"Duncan_J" wrote:

Hi,
I'm trying to do a vlookup in my macro. However spreadsheet one has 6
numbers and the other sheet adds # and letters after the 6 number. Is thier
anyway to get rid of the # and letters after the sixth.
Example:
834543
834543R7

742351
74235112

Thanks,
DJ