match index vlookup

[awiseman2]

I have a sku that i want to look up in a range and i want the find the amount of a certain supplier attached to that sku in the range, Does anyone know how to do this

 

[Fluff]

There are plenty of members here who could help, but you need to supply more information, such as what columns does the formula need to look at.
It would also help if you could post a small amount of data ( approx 15 rows) to the thread. There are some add-ins available here to help you do that. https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[awiseman2]

Apologies i'm new to this.
On sheet 1 i have unique values as i have removed all the duplicate values.
Unique values
Sku 1
Sku 2
Sku 3
Sku 4
Sku 5

I want to the look up the list of sku in sheet 2, which has multiple entries with different suppliers attached to them, i want to bring across to sheet 1 the count of a certain supplier (unique value) that has multiple entries next to that sku.
Multiple Values Suppliers name
Sku 1 Supplier 1
Sku 2 Supplier 1
Sku 3 Supplier 2
Sku 3 Supplier 2
Sku 4 Supplier 4
Sku 1 Supplier 1
Sku 3 Supplier 1
Sku 5 Supplier 1
Sku 5 Supplier 4
Sku 2 Supplier 1
Sku 5 Supplier 3
Sku 2 Supplier 2
Sku 3 Supplier 1
Sku 2 Supplier 4
Sku 1 Supplier 3

This is the outcome i want

Unique values Supplier 1 Supplier 2 Supplier 3 Supplier 4
Sku 1 2 0 1 0
Sku 2 3 1 0 4
Sku 3 2 2 0 0
Sku 4 0 0 0 1
Sku 5 0 0 2 1

 

[Marcelo Branco]

Maybe...

Formula in Sheet1 B2 copied across and down
=COUNTIFS(Sheet2!$A:$A,$A2,Sheet2!$B:$B,B$1)

M.