Cheers Roger ...

It is working fine now. Many thanks for your help.

Thanks once again,

Harish Mohanbabu


-----Original Message-----
"Harish Mohanbabu"
wrote in message
...
Hi Roger,

Thanks for your post. I did as you suggested and it
works
but not completely.

Both my sheets has got rows numbering to thousands.
When I
ran the command from Sheet1, I got matching results for
only first 10 rows. After that, though the exact match
is
there in the second sheet, I got "#N/A" message.

What could be wrong here? Please advise.

Thanks,

Harish,

VLOOKUP requires an exact match when looking up data.
You should be able to
see any obvious differences eg."." or "-" in the
CustomerID data but spaces
are not visible. Suggest you use the TRIM function to
clean up any
unneccessary spaces in the data - produce an extra
column with the =TRIM
function then copy and paste values back to your
Customer ID column.

The other problem can be mixing Text and Numeric data -
Numbers can be
formatted in Excel as either Text or Numbers and so I
suggest you
standardise your CustomerID field to only one of these
formats. Then use
the Excel functions VALUE or TEXT as appropriate to
change all your
CustomerID data to this format and copy/paste values as
before.

If your CustomerID data looks identical, has no extra
spaces and has the
same format in both sheets then VLOOKUP should match it.

VLOOKUP is a very useful function which will work with
your large worksheets
but it can be very slow, depending on the speed of the
PC.

Good luck,

Roger


.