please find attchment
M m9vukyem Member Sep 3, 2021 #1 please find attchment Attachments Check if Cell value exists in Column, and then get the value of.xlsx 9 KB · Views: 6
B bosco_yip Excel Ninja Sep 3, 2021 #2 In C2, copied down : =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(A$2:A$9)/(MATCH(B$2:B$9,A$2:A$9,0)>0),ROW(A1))),"")
In C2, copied down : =IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(A$2:A$9)/(MATCH(B$2:B$9,A$2:A$9,0)>0),ROW(A1))),"")
M m9vukyem Member Sep 4, 2021 #3 if the list a and list b is different area (i.e list a 15 rows and somewhere in the sheet and list b is 10 rows and not opposite to list a) not getting that result. Attachments reco.xlsx 172.8 KB · Views: 2
if the list a and list b is different area (i.e list a 15 rows and somewhere in the sheet and list b is 10 rows and not opposite to list a) not getting that result.
M m9vukyem Member Sep 4, 2021 #4 please Explain above formula how it works so that i can make formula as per my requirements
pecoflyer Well-Known Member Sep 4, 2021 #5 Could you please explain which these requirements are in words?