Should I keep Trying INSA - VLOOKUP?

  • Thread starter Thread starter Joe Chromy, Jr
  • Start date Start date
J

Joe Chromy, Jr

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 said:
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."
Click to expand...
Andy Partridge XTC
 
Back
Top