C
Chris Jewitt
Hi all, i'm having an issue sorting out some data automatically.
Currently i have 2 sheets I'm trying to combine using either vlookup or hlookup but can't seem to get it to work, possibly due to duplicated data.
At the moment i have 4 sheets, Sheet A, Sheet B, and Sheet C
Sheet B has data in B2-D4, With A2 having the person the information relates to
Example -
Dave,10,20,30
Sheet C, has
ROW 1, has the personal name duplicated with example, DAVE, DAVE, DAVE, JAMES, JAMES, JAMES.
The duplicates are next to each other
and below them has the data I'm trying to compare. example
DAVE,Dave,DAVE
11,22,30
ON Sheet A
i have A2 and below listing the persons name exactly the same as Sheet B. But B2,D2,F2 all represent data from Sheet B for what the person was expected to achieve
But Row C2, E2, G2 shows the data from Sheet C on what the person actually achieved.
The idea is to create a lookup on A2 on Sheet a that will gather data from Sheet C using a look up but also filtering out the fact their are duplicates. any ideas?
Currently i have 2 sheets I'm trying to combine using either vlookup or hlookup but can't seem to get it to work, possibly due to duplicated data.
At the moment i have 4 sheets, Sheet A, Sheet B, and Sheet C
Sheet B has data in B2-D4, With A2 having the person the information relates to
Example -
Dave,10,20,30
Sheet C, has
ROW 1, has the personal name duplicated with example, DAVE, DAVE, DAVE, JAMES, JAMES, JAMES.
The duplicates are next to each other
and below them has the data I'm trying to compare. example
DAVE,Dave,DAVE
11,22,30
ON Sheet A
i have A2 and below listing the persons name exactly the same as Sheet B. But B2,D2,F2 all represent data from Sheet B for what the person was expected to achieve
But Row C2, E2, G2 shows the data from Sheet C on what the person actually achieved.
The idea is to create a lookup on A2 on Sheet a that will gather data from Sheet C using a look up but also filtering out the fact their are duplicates. any ideas?