Vlookup formula issue - returning multiple values for one lookup value

[AndyT88]

I have the following formula which I am using to return a 'tick' or 'blank' if a 'Sample ID' correlates to a 'Type of Test' across 'The Table Array':

=IF(VLOOKUP(BS2,$BA:$BE,5,FALSE)=$BT$1,"✓","")

BS2 = SAMPLE ID NUMBER/ LOOKUP VALUE
$BA:$BE = THE TABLE ARRAY
$BT$1 = THE TYPE OF TEST

This is working fine. However, an issue arises when a unique 'Sample ID' has more than one test in the table array.

At present the formula will only pickup the first test, in the first row for that sample ID across the array.

How do I adjust the above formula so that it'll return all tests/ multiple values for each unique 'Sample ID'?

I hope this is clear. Please let me know if you need additional information.

Thanks in advance

 

[jasonb75]

If I'm reading it correctly, try

=IF(COUNTIFS($BA:$BA,BS2,$BE:$BE,$BT$1),"✓","")

 

[AndyT88]

Thanks so much Jason.

It works perfectly.

You sir, are a legend.

your help is really appriciated.

Regards