Hi All,
I'll appriciate your help by getting in table 2 values only ones (i'm doing v-lookup to sumif from table 1), per attached (without the yellow items).
Thanks for your help,
Hi All,
I'll appriciate your help by getting in table 2 values only ones (i'm doing v-lookup to sumif from table 1), per attached (without the yellow items).
Thanks for your help,
Sorry, Im unsure what your desired results are? Could you explain what you're looking to get as the vlookup you have is working correctly ie its pulling back the 1st occurence of the required record.
If someone has helped you then please add to their Reputation
Why are A & B in table 2 twice? Just remove them?
If you want unique list in G
in G3
=IFERROR(INDEX($A$2:$A$8,MATCH(0,INDEX(COUNTIF($G$2:G2,$A$2:$A$8),0,0),0)),"")
copy down
in H3
=IFERROR(VLOOKUP(G3,A:C,3,0),"")
Thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks