Hi!

Do the columns that hold the 20 variables have headers?

I'll assume that A2:A8 are the list of names.
B1:U1 are the headers for the 20 performance variables.

Two ways to do this:

=INDEX(B2:U8,MATCH("BOB",A2:A8,0),MATCH
("whatever",B1:U1,0))

=VLOOKUP("BOB",A1:U8,MATCH("whatever",A1:U1,0),0)

You can make these more versatile by using cell references
for the lookup and match values. In both cases, "whatever"
refers to the performance variable.

Biff

-----Original Message-----
Tab A has column A as "last name, first name" with a
performance breakdown
of about 20 variables listed going off to the right. I
need to extract 4-5
variables out of that information based on the name
column. To other tabs
taht are being set up based on name. I think it has to
do with a lookup
function but I'm not sure exactly how to set it up.

"Biff" wrote:

Hi!

It would be helpful if you were more specific.

Biff

-----Original Message-----
in tab A I have my Raw data. One of the columns is of
names. what I want to
do is in Tab B, where I have my analysis and my names
already listed, and I
want to copy the data from tab A to Tab B based on
that
name value. I think
it is a lookup function but I am not sure. Any help
is
of course appreciated.
.


.