Min IF not working

Question

Hi,

I am trying to retrieve the earliest data from a column with multiple possible matches... I know the formula is alright and know there values that should match, but still getting the #N/A across the board... example below:

	ID (a)	Name(b)	Date(c)	ID	Expected Result
1	AAAA	JonDoe	2011	AAA	{=min(if($a$1:$a$3=d1,$c$1:$c$3))}
2	AAAA	JonDoe	2010
3	AAAA	JonDoe	2013

the only difference in regards to the example here is that are lots of values ~700, and the lookup range in another workbook/sheet, but still I think it should work but it is not... I have done this formula before and works, but now not sure what happened (FYI I just upgraded my office/excel to the 2016 version).

Thanks,

Answer 1

If one of your 700 values is an error, that will force your formula to return the error. Look in the range used in the comparison (A1:A3 in your example).

Answer 2

HI Bernie,

Would never thought about that... It solved my problem easy! Thanks so much.