Hlookup/Vlookup with duplicate datas

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top