Search, If not found then add data in list.

[Deepak Sharma]

Hi All,

I need to search numbers from list 2 to list 1, If not found in list 1, then add then add that number in the bottom of list 1.

Please provide a formula to do so. Sheet attached !!!

Thanks & Regards,
Deepak Sharma

 

[bosco_yip]

In F102, formula copied down until blank :

=IFERROR(INDEX(I$2:I$101,AGGREGATE(15,6,ROW(I$2:I$101)-ROW(I$1)/ISNA(MATCH(I$2:I$101,F$2:F$101,0)),ROWS($1:1))),"")

Regards
Bosco

 

[Deepak Sharma]

Amazing !!! Bosco !!!!

Thank you so so much!!!!

Regards,
Deepak

 

[venkatesh]

In F102, formula copied down until blank :

=IFERROR(INDEX(I$2:I$101,AGGREGATE(15,6,ROW(I$2:I$101)-ROW(I$1)/ISNA(MATCH(I$2:I$101,F$2:F$101,0)),ROWS($1:1))),"")

Regards
Bosco

Awesome Bosco. I too had a similar requirement but from a different perspective. Did a workaround. But this cuts down my steps by almost 100%...!!!! Thank you Deepak for posting this!!!