Hi, i have big table with 60 000 rows. Example is in attachment (do not worry i used just 20 rows in example).
pokusne vzorce.xlsx
My 1st goal is to find ID ref/mut (column E) is sheet SNPs and return ref and mut allele.
So far I worked with VLOOKUP and it was working for IDs with only one copy in sheet SNPs, problem is vlookup return only 1st value, so IDs with more copies in SNPs sheet are problematic.
Is there any way how i can find all alternatives?

p.s.
sorry for my gramar, I know i have terrible writen english