Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HLookup vs VLookup | Excel Discussion (Misc queries) | |||
vlookup and hlookup | Excel Worksheet Functions | |||
VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
re : Finding the datas and deleting datas which are not found. | Excel Programming |