use vlookup function
anycell in sheet1 type

=VLOOKUP("dan",Sheet2!$B$1:$D$18,2,FALSE)
note the data base is from B1 to D18 and not from A1. the third argument is
2

similary on the right cell to this (or an;y cell) type

=VLOOKUP("dan",Sheet2!$B$1:$D$18,3,FALSE)
the third argument is 3

you will get the hang of it and modify to suit you.
=================

if change jason for dan you get
Jim wrote in message
...
Hello,

I would like to pull data from sheet two, then fill in the data to sheet
one.

Here is what the data from sheet 2 looks like:

A B C D
A1100 Dan 14 311.85714
A1102 Jason 12 296.83333
A1103 Brian 1 518
A1104 John 57 267.36842
A1105 Beverly 0 0
A1106 Jennifer 0 0
A1107 Chad 35 342.6
A1108 Brenda 1 243
A1109 Tina 2 193.5
A1110 Marcus 23 237.34783
A1111 Kelly 28 244.92857
A1112 Jim 19 425.94737
A1113 Michael 58 236.81034
A1115 Amy 9 282.77778
A1116 Teena 28 346.39286
A1117 Laura 65 204.04615
A1118 Randy 34 236.67647
A1119 Laura 4 278.5

Column A is the phone extension
Column B is the name of the Rep
Column C is the number of calls taken
Column D is the talk time in seconds

Although the data in the columns will never change, the rows in which the
data fills may vary.

I would like to populate sheet one A1 with Dan, B1 with 14, and C1 with
the
311.85714.

Thanks for the help.