Excel help please

Colcoops

I have 2 tables.
Table 1 has part numbers and peoples names against each.
Table 2 has part numbers and lots of other info.
I want the names associated with part numbers to be added to the part numbers in table 2. I don’t want to do it in access.

Thanks

village_life

are each of the "fields" in different cells!? - are you just wanting the part number and name to be in a single cell as freeform text, i.e. "mr smith [part code] xxx1234"

??

for linking data, access is better

Colcoops

village_life wrote:

are each of the "fields" in different cells!? - are you just wanting the part number and name to be in a single cell as freeform text, i.e. "mr smith [part code] xxx1234"

??

for linking data, access is better

the info is in different cells. I need just the name from table 1 to be put into the same row as the part numbers in table 2.

buglawton

I have a feeling that ASAP Utilities, a free Excel plugin that can do many wonders, can achieve this somehow.

If your Part Numbers appear in the identical row numbers in both tables, then you can open both tables at once, select and copy a column from table 2 and paste it into a spare column in table 1.

If both sheets contain the exactly the same list of part numbers you can force then to be in the same order by doing a data sort to get them into ascending order.

I started out baffled by Excel but this book (Excel Fast & Easy)
http://www.amazon.co.uk/exec/obidos/ASIN/1592000797/202-1826824-9847814
is worth having near the computer, to get you up to speed.

bolo

can yo unot use the vlookup function?

Colcoops

bolo wrote:

can yo unot use the vlookup function?

I have been trying to use this function but can't get my head round the microsoft speak

chuckles1066

Colcoops wrote:

I have been trying to use this function but can't get my head round the microsoft speak

assuming

the part numbers in table 1 are in column A
the names in table 1 are in column B
the part numbers in table 2 are in column A

then in table 2 (row 1, whichever column you want) you use

=vlookup(a1,'table 1'!a:b,2 false)

and then drag the formula down