I can't seem to get a Large formula to work based on two criteria's.

I can easily get a oldest value based one value, but I'm struggling to add another. See table below;

The 227 figure is based on =LARGE(IF(B:B="Jim",D:D),1) - so it returns the oldest days old for Jim.

However, when I want to the reference number as another search criteria, I get the #NUM error and have no idea why. Formula is as follows -

**=LARGE(IF(B:B="Jim",IF(C:C="2020",D:D)),1).**

Basically, I want to create a top 5 but have no idea why that formula does not work. Any help would be greatly appreciated.

Name | Reference | Days old | 227 | Jim Days Oldest | ||

Jim | 2020 | 114 | #NUM! | Jim and 2020 Days Oldest | ||

Jim | 2021 | 120 | ||||

Jim | 2021 | 227 | ||||

Sam | 2021 | 51 | ||||

Sam | 2020 | 47 | ||||

Jim | 2020 | 77 | ||||

Steve | 2021 | 290 | ||||

Steve | 2022 | 198 | ||||

Harry | 2020 | 84 | ||||

Jim | 2021 | 79 | ||||

Steve | 2020 | 77 | ||||

Harry | 2022 | 57 | ||||

Sam | 2021 | 54 | ||||

Sam | 2020 | 41 | ||||

Steve | 2020 | 41 | ||||

Jim | 2021 | 40 | ||||

Jim | 2020 | 32 | ||||

Harry | 2022 | 23 | ||||

Steve | 2021 | 73 |