i do not see how the data are placed, can you put a file online

--
isabelle



Le 2012-01-21 20:42, John Smith a écrit :


The values are there, but let me give you an example of what kind of
works. If I use the following:

.Offset(0, 5).Value = "=VLOOKUP(K"& r& " , EmpData, 11, False)"

it will give me the right answer only by chance. The problem is that
it returns the first value that it finds for the employee which may,
or may not, match up with the supervisor's name. The range may look
like this:

Supervisor
(E)
Work Area(O) Employee(P)
Jones
1234 Smith
Bennett
2398 Smith
Thomas
5555 Smith

If I select employee Smith (sh.3,K) and supervisor Thomas (sh.3,I),
then I need 5555 returned to sheet 3. The vlookup will always return
1234. Does that make it any clearer? Maybe there is a different way
to get the right answer?
James