Software

Ask something
Discussion Locked

copy data of one column quickly

0 helpful
2 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to copy the data of one column quickly into another column?

In Excel 2000, we have several columns, for example, first column for serial number 1, 2, 3 , , , , , second column for name a, b, c, , , , , ,
seventh column with discontinuous serial number, 2, 5, 1, , , , , , eighth column for price 20, 30, 80, , , , , ,
now we want to copy the data of eighth column quickly into third column, according to serial number
In Access 2000, it is easy to realize by using a Query; but how to do it in Excel, using a function?

2 replies

by dklippert

Could you clarify your question? Which serial number? The one in column 1 or column 7?
Is this one table/list or two?
One function to consider, depending on how your data is laid out, is VLOOKUP.

This discussion is closed to new replies.