can someone help me to get the codes

[JAlandhar 201718]

hello all,

can someone help me to get the codes, or how the formulas were placed

as i need to apply all this thing to another file.. so please help me

 

[AliGW]

LED Code:

=IF(B6="","",Entered_LEDCODE)

VOUNO:

=IFERROR(INDEX(DB!A:A,AGGREGATE(15,6,ROW(FDDR[VOUNO])/(FDDR[LEDCODE]=Entered_LEDCODE),ROWS($1:1))),"")

Drag copyboth formulae down.

By the way, your thread title and post explanation are both very poor - both could have explained your problem much better.

 

[bosco_yip]

Duplicated-post

https://chandoo.org/forum/threads/filter-data-to-another-sheet-by-cell-value.38676/#post-231469

Please don't open a new post, as your attached file was done/replied by Mr. Narayan and worked OK without any problem.

Should you have any query, please asking in stick to your original post.

Regards
Bosco