Excel Forum

Hi dear,

I need to compare report for BO list and LOS list.

I want to compare Staff code in BO list with LOGIN in LOS list.if it matches return LOGIN, BRANCH_CODE and NAME in REPORT

I also attached a template

Kind regards,

Match > Filter > Copy Paste

No.I need formula or vba to compare then extract to REPORT Sheet

Try these formulas:

1. B2
   =IFERROR(INDEX('LOS List'!$A$2:$D$1063,AGGREGATE(15,6,MATCH('BO List'!$B$2:$B$102,'LOS List'!$A$2:$A$1063&"",0),ROWS(B$2:B2)),MATCH(B$1,'LOS List'!$A$1:$D$1,0)),"")
   Enter > Copy to right and down.
2. A2
   =IF(B2<>"",ROWS(A$2:A2),"")
   Enter > Copy down.

Thank you always work fine