Hi,

I'm tying myself up in knots trying to get this to work.

I have employee test data in a single sheet.

K is a helper column with a unique number identifying the employee. M is the
Test and p is the result (1-5)

I would like to be able to set up a formula so that data stored in P can be
matched with employee in rows.

eg
Col A Col M Col P
Robert test 1 result 5
Robert test 2 result 4
Robert test 3 result 5

Emp test1 test 2 test 3
Change to Robert 5 4 5

Sorry I know not very clear
--
Deirdre