Hello, I'm trying to grab context from column A from looking at values in column K but the problem is column K has some duplicate values but column A will have different context. For example
For example column A and K:
A K
ABS 10
SBS 20
CDC 50
SED 50
SDD 40
SOM 60
EEE 70
Column T will pick up the value in column K. Forumla in column T =IF(SMALL(K$1:K$104,ROW(K1))<>0,SMALL(K$1:K$104,ROW(K1)),"")
T
20
40
50
50
60
70
And in column N or any other as an example will pick up A based on column T. As you can see below it's returning CDC twice when it should be SED. Please help?
=IF(T2<>"",INDEX(A$1:K$104,MATCH(SMALL(K$1:K$104,ROW(K1)),K$1:K$104,0),1),"")
N T
SBS 20
SDD 40
CDC 50
CDC 50
SOM 60
#NUM! 70
Bookmarks