• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Not Accurate Results 3 Way Lookup

Tech56

Member
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
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))),"")
 
Back
Top