Hlookup/Vlookup with duplicate datas
 

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?