G'Day everyone...

I am using Excel 2003. I have been trying to use vlookup = but I can't seem to
put my finger on it.
=IF(ISNA(VLOOKUP(A8,name,1,FALSE)),"Loss",VLOOKUP( A8,name,1,FALSE))

Here is my for instance

I have a long list of records (rows) (5000) with Column A being a number
beginning with 000000... 999999 (ascending sort). There is data in each cell
through column L. There is no incremental relationship between records.

I have a shorter list of 300 records with column AA being the sequential number
(sorted ascending) beginning with record 000564 through 899976. There is no
corresponding relationship between the numbers in Column AA. The number that
appears in column AA does anchor the record on the short list to the same record
on the long list...

I need compare the column A to Column AA and move Columns AB to AJ to the end of
the correspond record on the larger list Beginning in column "M"

Clear as Mud??? I hope someone can help.


Bravejoe

"That's my opinion. I could be wrong." Dennis Miller
"It Doesn't Matter!" Bravejoe

remove the "t1","us" and replace "com" with "net" from my email address to reply privately.

"There's fodder for the cannons and the guilty ones can all sleep safely." Andy Partridge XTC