sorry if i didnt attached any formula cause i really dont know how to establish it. i just know what should be the result.
thanks a lot in advance.
[TABLE="width: 743"]
[tr]
[TD="colspan: 6"]SORT OF DATA[/TD]
set of names
[/td][td]Value 1
[/td][td]Value 2
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]april
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 6"]Ho can I look for the names below from the sort of data above without coming [/TD]
august
[/td]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 5"]back to the first one I had look up already.[/TD]
august
[/td]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
december
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 6"]for example: using v-look up for finding the name august from the sort of data[/TD]
february
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 6"]above, its always yielding the same result which is august with 3,2 values but[/TD]
June
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 6"]what I want to look now is the august with 2, 3 because I am already done looking [/TD]
June
[/td]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="colspan: 3"]up with first august 3,2.[/TD]
may
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
may
[/td]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
november
[/td]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="colspan: 2"]hope you help me. [/TD]
[TD="colspan: 6"]Names to look up[/TD]
jan
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]feb
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]march
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]april
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]may
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]june
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]july
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]august
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]september
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]october
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]november
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr][tr][td]december
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/TABLE]