Find the serial number with criteria

Question

They want me to locate the 8-digit Pserial number for the oldest current smoker in the poll using my Excel database. If cigst is 4, the person smokes. Column 3 has the serial numbers, while column N lists the smokers. Column for age

This is the database, but the database also contains additional information:

I think the functions to use are INDEX, MAX and IF, but not sure on what order to use.

Answer 1

Use the filter function:

=FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4))

Maybe you have to replace semicolons with commas, depending on your Excel version.