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

Hi
you may start with the following link to see how VLOOKUP works:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Joe Chromy, Jr wrote:
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

if this formula is in column M of the long list and Name refers to
AA1:AJ300, then to pull the entry from AB into M you would use

in M2
=IF(ISNA(VLOOKUP(A2,name,2,FALSE)),"Loss",VLOOKUP( A2,name,2,FALSE))


in N2 you would change the 2 after name to a 3 and so forth.

the defined range "name"

Name: Name
Refersto: =Sheet1!$AA$1:$AJ$300

Now select M2:U2 and drag fill down the column.

--
Regards,
Tom Ogilvy


"Joe Chromy, Jr" wrote in message
...
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