hi Max

It wont work for me when i tried to upload it it would not let me put
anything in F1 or maybe i didnt explain myself prperly am so sorry am just
panicking. will start again if you could help explain in a novice form pls:

Worksheet 1 is called Master with all the stored information and is designed
as follows

Name Sex Age Height Occupation Education Religion


Worksheet 2 is designed as an inspection sheet as follows:

Person Location Sex Areapostcode Attitude Height


now what i want to do is if i type in a person's name in worksheet 2 i want
it to automatically fill in similar columns with worksheet1 i.e [Sex and
Height]

Regards

Lawrence

"Max" wrote:

One way ..

Assuming your "master" sheet is named: Master, with data in row1 down

In Sheet2,
Names would be entered in A1 down
Put in C1: =INDEX(Master!D:D,MATCH(A1,Master!A:A,0))
Put in F1: =INDEX(Master!BH:BH,MATCH(A1,Master!A:A,0))
Copy C1 and F1 down as far as required

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"lawmere" wrote in message
...
Hi, i have a big problem

i want to create a link between some columns in two seperate worksheets,
so
that when i type a name on the master sheet it would give me the required
information.Dont know if i explained this right, lets say on the master
sheet
i have columns : Name,Sex and Height on columns A,D and BH respectively i
want that if i type a person's name in worksheet 2 it should give me the
results on columns A,C,F in that worksheet. Please help i need it asap for
my
director