T Tech56 Member Feb 19, 2020 #1 I tried to apply these formulas to a workbook but the results are not accurate. Can you take a look at sheet 'Search Skills' ? Can someone please see what I am doing wrong? Thanks so much Attachments Search by Skills Rev 2.xlsx 24.4 KB · Views: 7
I tried to apply these formulas to a workbook but the results are not accurate. Can you take a look at sheet 'Search Skills' ? Can someone please see what I am doing wrong? Thanks so much
AliGW Well-Known Member Feb 19, 2020 #2 In B9 copied across and down: =IFERROR(INDEX('Source Skills'!B$1:B$100,SMALL(IF(('Source Skills'!$D$1:$D$100=$C$3)*('Source Skills'!$E$1:$E$100>=$C$4)*('Source Skills'!$F$1:$F$100=$C$5),ROW('Source Skills'!$F$1:$F$100)),ROWS($B$8:B8))),"")
In B9 copied across and down: =IFERROR(INDEX('Source Skills'!B$1:B$100,SMALL(IF(('Source Skills'!$D$1:$D$100=$C$3)*('Source Skills'!$E$1:$E$100>=$C$4)*('Source Skills'!$F$1:$F$100=$C$5),ROW('Source Skills'!$F$1:$F$100)),ROWS($B$8:B8))),"")
T Tech56 Member Feb 19, 2020 #3 Thank you so much I couldn't get my head around the formula. Now I see the logic.
