Copy multiple fields based on the info in 1 field

I

Idolminder

Field 1 has an ID number. Fields 2 through 6 have data.

On a separate worksheet I would like to be able to just enter the Field 1
value and have fields 2 through 6 auto populate with the data from the first
sheet.

Thoughts?
 
K

Kevin B

I would use a VLOOKUP function to return data in record based upon a field
entry.

Search Excel help on how to use VLOOKUP
 
M

Marcelo

Sheet1 has

Columns

A = ID
B to G = data

on sheet2 use on

b2 =vlookup($A2,sheet1!$A$2:$G$1000,2,FALSE)
C2 =vlookup($A2,sheet1!$A$2:$G$1000,3,FALSE)
d2 =vlookup($A2,sheet1!$A$2:$G$1000,4,FALSE)
E2 =vlookup($A2,sheet1!$A$2:$G$1000,5,FALSE)
F2 =vlookup($A2,sheet1!$A$2:$G$1000,6,FALSE)
G2 =vlookup($A2,sheet1!$A$2:$G$1000,7,FALSE)

on A2 enter the id that you need thed corresp data.

hth


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Idolminder" escreveu:
 
R

RagDyeR

You can use the Vlookup() function.

Check Help files and Debra Dalgleish's web page on the function:

http://www.contextures.com/xlFunctions02.html

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Field 1 has an ID number. Fields 2 through 6 have data.

On a separate worksheet I would like to be able to just enter the Field 1
value and have fields 2 through 6 auto populate with the data from the first
sheet.

Thoughts?
 
Top