Do I use Vlook Up here & if so how?

I know nothing about Vlookup and everywhere I read it's about #'s so I keep getting beyond confused. Then I think maybe a list is what I need. Can one of you amazing Excel Guru's take a look at what I am sure is a simple way to calculate how many waves are in completed/In Progress/Not started by WaveID?

I'd like to be able to do an array that will count how many waves by wave ID are within what status of running. See attached please: