Cross-Referencing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The problem I have is that our National Office staff send through monthly
reports regarding phone usage. There are around 600 transactions every month.
The reports do not have the cellphone users only their cellphone numbers.
I've been asked to match the names in the Master List to the New List. Is
there any way apart from Cntrl F to match the new list with my master list so
I can work out the cellphone user.

Example of data is as follows:

Master List New List
2001054 James Swindell 2001084
2001084 Jack Stewart 2001054

I have tried a Vlookup, but because the data is not an exact match, #N/A is
returned.
 
Hi MG!

Use the Text to Columns command and then your vlookup will
work.

Select the data range in your master list.
Goto Data>Text to Columns.
Select: Fixed width
Click: Finish

Your data should now be parsed into 2 columns. Now just do
a vlookup on column 2.

Biff
 
Hi Biff

Yes I went down this track yesterday, and after your response, tried it
again and it worked. It must have been too late in my working day to think
clearly.

Thanks.
 
Back
Top