how to transfer data from one sheet to another one

rendes

New Member
Joined
Dec 19, 2005
Messages
8
Hi,

In Sheet1, I have numeric data at the first column(A), and the definitions of the numbers at the second column(B).
In sheet2, I have used those numeric data in column A; each number several times, and not in an order; the second column B is blank. I want to transfer the definition of each number from sheet1 to sheet2 , to the next column of the existing numbers. How can I do that? Thanks,
Serhan
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

stuartford

Active Member
Joined
Nov 28, 2002
Messages
419
if ive understood you correctly a vlookup will pull the information you need from on sheet to the next

try this

=VLOOKUP(A1,Sheet1!A:B,2,FALSE)


stuart
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,697
Members
412,481
Latest member
nhantam
Top