Hi there,

a further help would be great. It looks it up perfectly if there is one hit and finds the first country in columbn A with =VLOOKUP($P2,$A:$N,COLUMN(A$1),FALSE). Sometimes unfortunately in example the country Algeria is twice or more often in column A is there a way that excel like below:

A1
country1
country1
country1
country2
country2
country3
country4
country5
country5
country5
country5

Thanks for any help!