VLookup help Office 2003 Professional

[Andy B.]

I am working on a project for school and I was wondering if I could get some
help. I have a list of part numbers in column A and columns B-Q contain
supporting information for the part numbers. Another list of part numbers is
generated at certain intervals that may or may not contain some of the part
numbers from the prior list. We are attempting to find a way to transfer the
old information from columns B-Q to the corresponding part numbers on the new
sheet instead of having to retype hundreds of entries by hand.

I tried using Vlookups, but the index_number can only be one column from
what I've found. Ideally, if there would be a way to vlookup based on the
number in column A and import the information from B-Q, I would be very
happy.

Any ideas anyone?

 

[Pete_UK]

Try this in B2 of Sheet2:

=IF(ISNA(MATCH($A2,Sheet1!$A:$A,0)),"",VLOOKUP($A2,Sheet1!$A:
$Q,COLUMN(B1),0))

Copy across and down as required.

Hope this helps, but you should really try to do your school projects
yourself.

Pete

 

[T. Valko]

Try it like this:

=VLOOKUP($A1,Sheet2!$A$1:$Q$100,COLUMNS($A1:B1),0)

As you drag copy across the col_index_num will increment as needed.

Adjust the ranges to suit.

 

[Andri]

Try

=IF(ISERROR(VLOOKUP(J49,K47,1,FALSE)),"",CONCATENATE(L47," ",M47," ",N47,"
", O47...))

L,M,N,O representating col B- Q...

HTH